Speaking of left-handed bass, I always assumed that Paul McCartney was a bass hero. He certainly is a superb composer/singer/musician, and a hero of mine in many ways. But listen to "Get Back", with separate tracks for each instrument. I feel a little silly critiquing McCartney, but to my untrained ear the bass does not sound particularly steady (or imaginative). Perhaps someone with more experience can weigh in on this.
http://www.youtube.com/watch?v=ZRpdqBT_0D0
If you want to skip to the bass, it starts at 5:04.
Here is when each instrument appears: Guitars: 0:00-2:35, Drums 2:36-5:04, Bass 5:06-7:50, Electric Piano 7:52-10:41, vocals, full band.