Dragon Age Origins has the best most intuitive camera I've ever seen in an RPG. Mouse wheeling quickly and seamlessly between an immersive OTS view (with free mouse look) and a tactical view.