we got into a very large argument discussing this very same topic last time, anyways the conclusion is:
There are limitations to both Azure and Windows Hosting. So I am trying to put cons here for both of them (best to my knowledge) you can decide if you like ;)
Azure's Cons:
1.When using a web hosting company you can put up any code that you want. Whether it is scalable or not is strictly left up to the person writing the code.Windows Azure is a little
bit different. When writing code to run against Windows Azure the patterns that you are forced to follow to make it compatible ensure that it is scalable.
2. Microsoft is a huge corporation and cant provide the level of the support we are used to by the other companies
3. I personally think 99.7% uptime is less while other hosting providers guarantee 99.9%
4. Its costly and also features other facalities like sliver light application hosting etc. etc.
WebHosting Cons:
1. You are right about the hosting providers not being serious these days I had the same experience with
Arvixe but there are still few excelling shared Windows Hosting providers left like discount asp and
phi9.com which sell their services
cheaper then Azure with
phenomenal support.
2. Most of them dont live upto the up-time guarantees and have lesser money back guarantee period.
3. I personally like the support element if you can find any hosting provider with great support you should stick to it.