Have to chip in here...
As a passenger in a light single - then having a pilot who makes it fun, one who enjoys the flight. As opposed to one who spends the whole time looking nervous and focused on the job in hand. Of course that is how all pilots are (focused I mean) but if the pilot exudes confidence, and appears relaxed then it's better.
As a pilot - well I did't go far enough to realy comment but I'd say one who believes in their ability and always has fall back positions. Right down to the "sod it - we just don't go one" - its a pleasure / hobby thing remember not a a mission.