Aren't Radiohead an Alternative Rock band?
Stone Sour's vocalist (also the vocalist of Slipknot) Corey Taylor is an excellent vocalist.
A more soft, melodic song: https://www.youtube.com/watch?v=GIzDsGyxsQM
A heavy song: https://www.youtube.com/watch?v=_tmxCRRmNhM
Avenged Sevenfold also has a good vocalist.
A melodic song: https://www.youtube.com/watch?v=A7ry4cx6HfY
A heavy song: https://www.youtube.com/watch?v=HIRNdveLnJI
There are many Heavy Metal bands with talented vocalists. Even Marilyn Manson deserves some credit here:
Heavy: https://www.youtube.com/watch?v=w5LZ8YErl2M
Melodic: https://www.youtube.com/watch?v=X9BEjwI5DJg