RDR2 has a good camera mode and the game and it's dynamacism really does it justice. Very beautiful, atmospheric, and dynamic game with a lot of variety. I spent an insane amount of time in the cemera mode in that game. A game that impliments it in a more gamey way would be Dead Rising. GTA5 and online has it, but online is a while can of worms of a game I wouldn't exactly recommend people get into. I can't really recommend anything from Rockstar just because it's an evil company, so do with that what you will.
https://www.youtube.com/watch?v=xwoX0vLVnfQ