This could be a good idea for some skateboarding replays or any mods that have moving object in it. You just have to press a key or maybe a shortcut keys to enable it, then you move the camera to an object you want and it'll stick there.
Sorry, i don't have any example video for this one, i can't find any :/