A lot of good responses here ( I particularly like Dave Mattacks and Jim Keltner as rock drummers and Jack D. for Jazz). Since, as Tvad points out, the question regarded musical drummers, I'd also look to less obvious people like Cal Tjader. He may be better known for vibes or even bandleading and songwriting, but he brought that broader sense or "musicality" to his drumset and congas, Latin Jazz was full of this phenomenon, see Tito Puente et al. Mick Fleetwood, Will Rigby, Jim Brock and Phil Collins would be somewhat analagous in the rock world IMHO.