I've made an RPG camera system. It works for player 1 only, but it works fine.
You can change the distance & rotation by arrowkeys. To change the perspective use mouse-wheel. The currently selected unit is the target of this camera, so you can use it for more than 1 character.
Feel free to optimize it for your own, if it isn't exactly what you need. Have fun with this. ;-)