Websites in Windows Azure is not just for hosting your own developed websites you can also choose from a gallery with applications. You can for example usa WordPress, Joomla and Drupal. In a few minutes you will have a running web application in the cloud.
To create a website in Windows Azure, go to the Windows Azure portal and click new then Compute -> Web Site -> From Gallery
Then you get a dialog where you can choose an app to install.
Azure Websites is free to use, but if you need better performance you can upgrade your web site, read more here, http://www.windowsazure.com/sv-se/pricing/details/virtual-machines/
If the app you want to install using MySql you will get 20 Mb for free.
We using Azure Web Site for a project portal for our WordRoom-project. We using Incentive for that, a very good portal including blogs, wikis etc. It’s free to use for up top three users.