Personally, I like the classic 3rd Person camera that is used in various 3D Mario Games.

If you've played Mario 64, that's what I'm talking about - the camera is 'static' when the player moves, but when the player is idle, it rotates around to give a view of what's around you. Mario Galaxy was good when it did that, as it allowed you to see what dangers are ahead (black hole, etc).

If you're making a Halo-shooter, try a GameCube Metroid 1st-Person view. Make it like the player is actually "inside" the suit/character and the HUD is on the screen, etc.