There was a review article of tent stake holding strength here on BPL a while ago.
I'm not sure if you need to be a member to view it, but here it is:
In short the winners, in no particular order, appeared to be:
1. MSR Groundhog
2. Easton Nano
3. Other aluminum Y-stakes
But these are all the heavier end of lightweight stakes, if that makes any sense. They weigh 0.5-0.6oz apiece. Simple wire skewer stakes or hook stakes will work in many conditions and weigh less than half of that.
So a lot of us use Groundhogs or Nanos for tarp ridgelines or the corners of a pyramid, but skewer stakes for guylines and other odd stake loops.
Predictably, the longer (and thus heavier) a stake is the better it holds, but the ones listed above also had good holding power for a given length.
This BPL article is one of the reasons MLD distributes Easton stakes.