The most spectacular single shot film I’ve ever watched is Russian Ark by Alexander Sokurov. I have the dvd but it’s worth seeking in any available format.
Also, and perhaps inspired by this movie, the pilot for Battlestar Galactica begins with a five- (?) minute-long single shot that introduces most of the lead characters.