Oh good! A character is blessed with a special ability or condition. But wait! Instead of the character liking the special ability, it turns out the character thinks the special ability they got sucks. The dissonance between how the character got the special ability and how they view the special ability itself is at the core of this trope. As such, this is an In-Universe only trope.
Blessings are any positive events or a series of positive events whether that be an actual blessing or positively Applied Phlebotinum. If the character likes the events that lead to them getting the special ability before they decide the special ability sucks, then it counts as a blessing.
Reasons for a character to think a special ability sucks are too numerous to mention. If their main attitude is that the special ability is usually awesome and only occasionally sucks, then they do not qualify for this trope. This trope is about "Awesome" verses "Sucks", not about "is Useful" verses "is Useless"; utility and desirability are not equivalent for this trope.
Some of the more common reasons for a character to not like a special ability include Useless Superpowers, A Mind Is a Terrible Thing to Read, Power-Upgrading Deformation, Who Wants to Live Forever?, So Beautiful, It's a Curse, Immunity Disability, Does Not Know His Own Strength and anything on the Power at a Price index.
Compare/contrast What Kind of Lame Power Is Heart, Anyway? where it is the uselessness of the character's special ability that makes it suck, not the way the character thinks about the special ability regardless of how useful the ability turns out to be.
The inverse is Cursed with Awesome, where it's the events that are negative and the special ability that is positive. This trope is also Older Than Feudalism, and is a perfect way to teach the Aesop of Be Careful What You Wish For.