The hero Ural in Bashkir legend definitely has both Super Strength and the requisite anchoring power. He managed to lift a great big stone (in the challenge to win a princess and a demon-blooded winged steed... devised by said stallion himself), but his brother who tried before him didn't have these secondary powers and ended up buried waist-deep. Before this, a great bull buried himself knee-deep in a futile attempt to lift Ural while he was holding the bull's horns.
A similar tale is told about Svyatogor. He boasted that he could turn the entire earth, so he was challenged to lift a bag which later turned out to contain all of its weight. He ended up knee deep in the ground, and (according to some variants) died there. He's also usually portrayed as too heavy for Earth to carry him due to his strength, which is why he usually stays in his mountains and cannot go anywhere else.
Older Than Feudalism: This trope shows up in Classical Mythology with Midas. Wishing that what one touches turns to gold certainly can have some horrible downsides (and economic consequences). The man lacked such necessary powers as "not turning food and water and people into gold." He didn't turn air into gold, though, nor the contents already in his digestive tract, so he survived just long enough to learn his lesson and beg for a wish reversal.
It shows up also in Classical Mythology with the Cumaean Sibyl and Tithonus who both asked for immortality but both forgot to ask for eternal youth...well, it was Tithonus' lover who asked in his stead but the result was the same: they withered away and in the end only awaited a death which would not come.
In a Shout-Out, "Tithonus" is the title of an X-Files episode about a man with immortality, but who's also stuck in middle age forever. He's started to forget parts of his past, like his dead wife's name, and wants only to die. Unlike in the myth, his wish is finally granted.