Your idea seems quite fun. After reading your post my mind went straight to the ‘Set View Target with Blend’ node.
Switching Between Multiple Fixed Camera Perspectives
A previous thread goes over setting the Player Rotation.
How to Set player Rotation?
I am excited for you and I hope you find success in the suggestions above.