In Rock, to me the most musical, melodically that there was is Ringo Starr. he didn't need to be an army marching in on a thunderous, deafening attack. he was just the right drummer for the Beatles. He made it all look simple. I saw the likes of Karl Palmer, Keith Moon, Charlie Watts, Nick Mason, Stewart Copeland, etc., but I still prefer Ringo.
Best Rock Drummers
I've seen most of them and by far the two that stand out are Neil Peart of Rush and Ceasar Z. of Golden Earring. For non-rock I would say it's a no brainer with Buddy Rich.