Want to get more details about Windows Azure? There is a really helpful video done by Channel 9 that talks about this upcoming product and how it works.
I think this gives great details about the architecture and also how you will use this and what it will be good for. Check it out:
There are a bunch of other details you can find out about this product so feel free to post your favorites in the comments.