Like most here, I prefer single players for all the reasons listed and I particularly like playing accomplish the game design objective (i.e. light the special) much more than getting points. I tend to have my point levels set pretty low (as encouragement for people who come over to play), but they are secondary to getting a replay via the special.
That said I agree with Hoov that it's nice (if you have space) to have at least one multi-player around as a change of pace and for parties. I have had a slew of good ones (Royal Flush, Jack in the Box) and have currently have a Quick Draw. All my other games are 60's 2" flipper so it also represents a change there. With only room for 5 games (really 4 put I pushed it), I'm trying to create a range of game play/playfield toys:
Drop Target (QD)
Roto Target (KOD)
Swinging Target (Heat Wave)
Kickout Hole (Sing Along)
+ Nags which has the turntable and novelty of horse racing.
Bottom line, they are all good. As I always say, if I had room for 20 games, I had 20 games.