For open world action RPGs I like first-person. It's best for immersion.

For tactical, turn-based or most other RPGs I think Dragon Age did it perfectly actually… let you zoom in to see the world and explore and then zoom out for combat.