In pop music, Freddy Gambrell's intro on Benson's reworking of Leon Russell's "This Masquerade" comes to mind.
I also like the intro to King Curtis' "Do you have Soul Now?" I don't remember who played it--- was it Tommy Flanagan? It is on the "In a Jazz groove" Album.