I love the idea of virtual tours - especially if built into your phone. Here I'll list any great apps or ideas I've stumbled on, or others have showed me. :)
Virtual Tour Apps
- Detour - Location aware audio and visual tours of San Francisco from your mobile phone.