Most high end superpowers get really boring, because there should be no way they can be overcome. The Enchantress in Suicide Squad was rubbish because she should have been able to stomp them all and she only lost because she was stupid and made a mistake, rather than them actually beating her.
There needs to be balance. A superhero - or villain - needs to be powerful enough to match their opponent without being totally insurmountable. Doc Ock vs Spiderman is probably the high water mark for me.
Dr Manhattan is a different kettle of fish, because he is supposed to embody this trope as being totally over the top powerful, but he's also so disinterested as a result of this power that he doesn't care.