I think it all depends... if I unleash it and it's really powerful, then I don't mind watching everyone scatter about in an attempt to avoid its unbridled wrath. If I send out a goldeen or some other pokemon that just flails about the entire time it's present, then it's definitely going down on the "least favourite" list.
If someone I'm battling unleashes a powerful one, though... then I'm right with you there. Palkia's rotation gimmick is awful, and those that render you dead upon their touch aren't too great, either.