I actually kind of like some screaming in certain songs. Fuel's song "Down" has just enough screaming that it's pretty darn cool. I also like "What if" by Creed... I love how he keeps screaming "What if, what if, what if I?"
To me it has to be mixed in just right, and there absolutely must be heavy guitar to balance everything out IMO.
One thing I really don't go for, however, is Cannibal Corpses. One of my friends likes them... all I can say is whew... now if anyone takes the cake for the most deep growl/screaming music, they do. Period.
