I best remember Chester Thompson for taking over the Genesis drums when Collins moved to the mic, and Aynsley Dunbar for playing with Journey during their proggier experimental days.
As for the Zappa drummers, Bozzio was good, no doubt, but my preference leans towards Wackerman. He kept some insane time sigs (as per Zappa, of course) and has been damn good in everything I've heard from him. Most Zappa fans haven't forgiven him for using Simmons electronic drums during the '84 tour though.