In the opening of the second season of K-On!, there is an orbital shot around the whole band as they're playing in the music room.
This is seen in the first episode of Fate Zero, as Kirei is told about the Holy Grail War.
In Bad Boys 2, when the villain calls the heroes to inform them that he holds the lead girl (who happens to be one hero's sister and the other's girlfriend) hostage, the camera does a dramatic Orbital Shot as one of them delivers the punchline "Shit just got real!"
Sent up in Hot Fuzz, where the camera spins around the protagonists as they deliver these immortal lines:
The Joker and Rachel in The Dark Knight "You wanna know how I got these scars?"
In the just-begging-for-a-Rifftrax horror film Darkhunters, there is a scene where a demon is holding Carol Miller by her jacket and pulling her up to his face, and while they talk the camera is constantly panning around them. It's not a continuous shot but a series of half-orbits around the two of them, zoomed in close to their faces. Watch it here starting at 51:50. It lasts nearly three minutes, so have a bucket handy...
Dizziness exacerbated by forcing you to read subtitles during the whole thing!
A fairly brilliant one in Murder in the First, orbiting a cell set in the middle of a room. Thanks to flyaway walls, the camera appears to move in and out of the cell.
MegaTokyo did this in five panels, in the middle of a fight in a crowded nightclub. It's about as confusing as you'd expect, and it's entirely possible to miss the fact that it's the camera that's rotating, not Kimiko.
In the finale of Danny Phantom, Danny and Sam get one during a romantic moment.
Used forebodingly in Watership Down, when Hazel's group are inside Cowslip's warren. They're bunched up in the middle of a large chamber with multiple entrances, and the perspective rotates around the room, looking at them through each entrance in turn. It's creepy, because two or three resident rabbits crouch anxiously inside each tunnel, out of the newcomers' view, and are eavesdropping on their conversation.