Agreed on Benmont Tench......not flashy, but played within the parameters of the band and enhanced the song.

Also off the top of my head in the same vein:

Garth Hudson/Richard Manual (The Band)
Bill Payne (Little Feat)
Blue Weaver (lots of bands and session work)
Chuck Leavell (Allman Bros, Sea Level and session work)