Vancouver to Whistler is approx 2 1/2 hours, on a windy dangerous highway. There are plans to upgrade the Sea to Sky Highway. There may also be buses and or trains during the Olympics.
Tickets are not yet available (not to the general public anyway).
You can check out the website at
www.vancouver2010.com
We are about 45 mins from downtown Vancouver. DH and I were in Sydney for the 2000 Summer Olympics (our Honeymoon) - my dad and brother were technical judges at the track and field. And I went to the Barcelona 1992 summer games - I was 20 something and living in London and a bunch of us decided to go to Spain, we stayed at a campground and ate lots of bread and cheese in order to have money for tickets. I also went to the 1994 Lillehammer winter games - the guides and scouts of Norway hosted Guides and Scouts from around the world. It's an experience well worth it. And yes there are some disadvantages, but I still think its an awesome experience