I agree that the camera is terrible often, especially in very vertical areas with several levels above each other, such as mountains, caves and buildings.
Moving the camera so that you see where you want to go or where the enemies are is difficult sometimes.
Also moving the chars in such areas can be hard, like you want a char to move inside the building and he always wants to climb on the roof or you tell chars to go somewhere and they damage themselves by climbing up and then falling down.
Another problem is that the camera jumps between characters in combat, so sometimes only the combat log tells you if you hit or miss.
For RPGs I prefer an isometric camera because it usually gives the best overview.
Isometric as in "with an angle from above", not isometric in the mathematical sense.
I was surprized that there is even a wikipedia entry for this: wiki