There are whole trope pages dedicated to this concept. I'd start with the abilities noted there and then simply point to the myriad D&D methods of obtaining these abilities.

Required Secondary Powers
Blessed With Suck
Too Awesome To Use