Looking for some (good) melodramatic rock

You don’t get much more melodramatic than “The End” and “When the Music’s Over,” by The Doors. After their first two albums, I don’t think they meet the stipulation that it be good, but for that brief period they were great.