Several examples of the long shot used well:
http://dailyfilmdose.blogspot.com/2007/05/long-take.html
I'll add to this list Dead Again. There are a few long shots in it, notably one which was filmed as a single long shot but got edited down - the first hypnotism scene in the antiques shop. It was actually a dolly shot, because they wanted smoother movement than a steadicam could provide, as it circled slowly around the room. The challenge was to make the room big enough for the camera and the track, but still make the space feel small and close.
There are other long shots as well... I may have to watch it again to note some of them. Been thinking about writing on the use of objects as narrative in film, and Dead Again has some wonderful examples of that.