I'm always looking for new 'soundcheck beats' or intro ideas so I made a list on Spotify and it's over 900 songs now. It covers a lot genres and types of intros from a one bar of toms Phil Collins-style to a Questlove flam that has a ton of attitude.
I recommend listening on Shuffle mode to not only get inspired but also discover some new music... or relove some once familiar ones.
Send me a message if I forgot that one song you need to have on there...
One drummer who definitely deserves more recognition is Budgie from the ever evolving Siouxsie and the Banshees. His drumming was always a bit left of center by staying away from by-the-numbers rock beats and creating actual parts for songs. He wasn't incredibly technical but he played drums like a producer... never worrying about licks and tricks... just enhancing the melodies and creating a bed for it all to lay in.