Some of my favorites have already been mentioned:
Motorhead - Lemmy
X - John Doe (part-time lead singer)
The Cars - Benjamin Orr (part-time lead singer)
and of course the Beatles - Paul McCartney (part-time lead singer)
Some other favorites:
Beach Boys - Brian Wilson (part-time lead singer)
Teenage Fanclub - Gerard Love (part-time lead singer)