Then, just because I annoyed one of the high-profile kind of member, he closed the question. Is it a fair move? Should we tolerate this behavior because SO is running autopilot with the agenda: high scorer is free to twist anyone? Or should we expect some openness in this platform?
This is not possible. Closing a question requires five (5) different users to agree with the decision to close and cast close votes of their own. There is no way that a single user, regardless of reputation, can close your question single-handedly.
However, moderators (that have been elected by the community) can close a question. These users' names appear with a diamond after them (♦) and serve much the same purpose as moderators in any other community. In the case of your most recently closed question, Bill the Lizard ♦ closed it as "not constructive". (In another case, 5 different community members agreed that it was off topic and closed it.)
I agree with that decision. Check out the close description that appears along with the closed bar:
This question is not a good fit to our Q&A format. We expect answers to generally involve facts, references, or specific expertise; this question will likely solicit opinion, debate, arguments, polling, or extended discussion.
That sounds like it fits your question pretty well. You're asking for a comparison between cloud and VPS hosting services and a specific recommendation for your purposes. That's not really a good fit for our Q&A format. Questions like that are often to solicit opinions (rather than facts), and devolve into a subjective, extended discussion.
I also don't think this question is on topic for Stack Overflow. Web hosting is only tangentially related to programming, which is what this site is explicitly about. The question could have been rightfully closed as "off topic". Consider it closed for that reason instead, if you prefer.
And just because you can find other similar questions that haven't yet been closed does not provide sufficient evidence that your question is valid for this site. All questions must be evaluated independently based on their own merits. It's always a possibility that those other questions are ones that should have been closed in the first place, but have simply been missed.
But if you really think that your question has been closed unfairly (whether by the community or by a single moderator), you've done the right thing: Post a question here on Meta protesting the decision.
If the community agrees that your question was closed incorrectly, then users with close vote privileges can cast votes to re-open the question, and/or a moderator can re-open the question immediately.
In this case, it's very unlikely that the community is going to agree with you. As I mentioned above, this close decision was completely valid and fair. It was not based on your offending another user, but rather on the content and nature of the question itself.
However, do note for future instances that it is far more productive to take a neutral tone when protesting a question closer. Accusing specific users of unfairly targeting you or your contributions is a pretty serious accusation, particularly when you have no basis for it. Comparing actions taken by the members of the community to the PATRIOT Act is very likely to offend, and that's quite counterproductive for you.