Am I able to set the camera angle to a certain block at a certain angle in singleplayer? Specifically speaking, like this (starts at around 13:40):
Of all the camera mods out there, the most popular is Camera Studio. This mod allows you to record timelapses, 'render' scenes by slowing down the world to get higher output FPS, as well as control camera position in a number of ways.
It is an advanced mod, so be prepared to spend a bit of time getting to grips with it to get the results you want.