Although Security Stack Exchange is better than many sites, I agree that people are petty about being on-topic, and particularly with close votes. I asked one about Windows 10 that I think is a really useful question for the site, and to my surprise it was closed. I've also had a question closed by community votes then reopened by a moderator. The way the close vote queue works seems to encourage a kind of hive mind, where a single close vote quickly progresses to five. To be honest, I've largely given up on asking questions here, although I do enjoy providing answers.
The guys on StackOverflow have discussed this issue at some length (sorry, I don't have links to hand). They talk about signal to noise ratio, and reckon you need to be strict about keeping posts on topic to keep the signal high. I don't agree with that, I am lenient about posts which are borderline. I think signal to noise ratio is not that important, because search works well. But the thing about being part of a community is that you don't get to do everything your way.
A couple of things that may cheer you up:
If people read your post and think "interesting question but I don't know the answer" they tend to move on without comment. This inherently means that comments visible will be more negative that the general mood. That's life online - either deal with it, or stop using internet forums. Also, I tend to reserve upvotes for things I am particularly interested in, and I don't "sympathy upvote" if a reasonable question is already downvoted, because that causes a net rep change of +8, practically the same as a straight upvote.
Also, consider that the knowledgeable people on this site are mostly motivated to answer interesting questions. Whether it's to practice writing skills, build an online profile, whatever. That is their primary interest; helping you out is secondary. If you don't like that I think your only option would be to pay a consultant to answer your questions. The experienced guys here will charge $1000+ per day - but you're getting them for free.