Yes, absolutely would be great to at least be able to tilt the camera up/down. Like, the "tactical camera mode" already exists so obviously the functionality is already there to some extent.

Another potential improvement would be the ability to raise/lower the camera. Together with the above it would make it a lot easier to take a good look at some bigger structures. As it is right now, it's very easy to miss places that are high up if you haven't seen the place from a distance before, because the camera just never points at them. For example, a certain building in the Blighted Village has a belfry, which I only found out by complete accident after already spending a good deal of time around the village.