Please note that I use "you" in my answer, but this could refer to anyone who can benefit.
See the "make it relevant to others" section of ask advice, which is an adaption from Google's Tips...
The story might make the question too localized/specific, but that's not the reason I've closed it for.
As I were one of the people who decided to vote for a close these were my thoughts:
1 -> inspire answers that explain “why” and “how”.
4 -> invite sharing experiences over opinions.
5 -> insist that opinion be backed up with facts and references.
The question asks for opinions and does get different opinions as an answer.
They all say you should do something, this doesn't result in an useful decision...
As nothing is backed up by experiences/facts/references, there is nothing to base your decision on.
3 -> have a constructive, fair, and impartial tone.
As there are a lot of different opinions, the answers aren't constructive towards a decision.
This is what the close reason is about.
There can be questions that have constructive opinions that can help you create a subjective answer...
2 -> tend to have long, not short, answers.
6 -> are more than just mindless social fun.
These two are just fine, but not enough to have an overall effect.
While it seemed a bad idea to leave some questions open, it now seems a bad idea to close some questions.
To answer your questions:
In my view, if I can't post something like that here, then which SE site is appropriate for it? Any?
Or was it just a matter of how the question was asked?
The question is on-topic, but as it isn't subjective in a good way it might not be useful in its current form.
I would suggest to reform it to match the enforcement notice more, so it invites experiences and then the rest would come automatically. Please note that the notice isn't there to enforce questions that are solely based on experience, but experience tends to work out better for a question to be useful...
It is a bit frustrating, because the question generated a lot of good answers and those answers helped me a great deal, but now if these types of questions aren't welcomed here, then where can someone turn to?
Sorry, perhaps I looked wrong at the answers that where there when I voted? I'm in for re-opening.
Reforming the question might help, but feel free to disagree with me...