Some of the Bike-O-Vision DVDs are pretty decent for that. The ones that keep the camera pointed up the road the most and break the "virtual reality" the least are St. Croix, Puerto Rico, and Death Valley. Just you and the road with these.
The Spinervals On the Road DVDs are good, too. I like the Tucson Training Rides DVD best of those, but the other two are good, too. With these, you're following the Spinervals guy Coach Troy most of the time although there's also footage from Coach Troy's helmet cam.
I also have a DVD called RIDES: Las Vegas/Valley of Fire that's not quite as "virtual reality" as the others I've mentioned(mainly because of some of the camera angles), but it's nice because it involves a group of cyclists and the workout has you changing what you're doing pretty often which makes the time pass quickly. There's also a Rockies DVD in that series which I'll likely buy sometime.