The evil queen and her lover died when a pile of brick and stone from the castle fell on them. And the dragon queen died when her lover (Jon Snow) stabbed her near the throne of iron. I guess the lesson learned here is to not have a lover.
Note Worm's girlfriend (and lover) was beheaded in the previous episode; so that doesn't really count for this question. But it does affirm my thesis about the quick demise of lovers in this series.
And, no, I thought the ending wimped out. A better ending, I think, would have been for Snow to kill the dragon queen, have her dragon incinerate her, and then he climbs onto the dragon; flies it onto the steps in front of all those people and soldiers and declares himself King of the Seven Thrones.
In all the episodes, Jon Snow was the only other one to ride a dragon; so we the viewers would have believed it when he climbed aboard the remaining one.
And he was up to the very end a strong supporter of the dragon queen; so her followers would have followed him. With her body incinerated no one (except the dwarf) would have suspected that he, Snow, had killed her. And the dwarf would never tell.
I think the above would have been a much better and more plausible ending.