I'm not a big fan of god like people or races.
DS9 must have annoyed you then considering how huge a part god like races play in that.
TNG as well.
Actually the Prophets and Q only appeared in a handful of DS9 and TNG episodes. I didn't mind them since the writers took the time to develop them as characters.
The only ones that bother me are those that appear and are never heard of again. That seemed to happen often in TOS.