Starcraft 2: 8 Medivac drop

[Kyeudo]

it also takes a lot to make them, and they never struck me as particularly good in any part of a game..

You need to rethink your assessment, or I will have to kill you with mass queens.

Queens are certainly not a super stand-out unit like the Infestor, but you can do crazy things if you have enough queens. Just check out this Funday Monday, back when Queens had short range.