Interesting thread! This is all I can think of at the moment:
Between the Buried and Me - they use C# standard on all their albums.
Dark Tranquillity - use standard C# all the time also.
Deftones - dropped C# (at least on the album 'Around the Fur'), but not a good band.
Slayer - from 'Diabolus in Musica' onwards, a lot of their songs are in dropped C#.
Pantera - the album 'The Great Southern Trendkill' is in this tuning.
Machine Head - I've only heard the album 'The Blackening', and most of the songs on that are in C# standard.
Nevermore - they have a couple of songs in this tuning: The Psalm of Lydia, and Seed Awakening.
Nirvana - the song 'Heart Shaped Box' is also in this tuning.
Nevermore and BTBAM are the only ones from that list that I actually recommend you check out.