
Y-Stake Tent Stake
The Y-stake gets its name from the Y shape of the stake from the top view. Y-stakes resist bending, are more durable, and don’t easily spin in the ground. High grade aluminum is commonly used to construct Because of this Y-stakes are very durable and provide good overall holding power.
MSR Ground Hog Stake: 7.5 inches, 15 grams, $3
MSR Mini Ground Hog Stake: 6 inches, 9 grams, $3
(not a comprehensive list)

V-Stake
The V-stake gets its name from the V shape of the stake from the top view. The V-stake resists bending and does not easily spin in the ground. V-stakes are commonly constructed out of titanium. However a V-stakes are not as durable as Y-stakes. V-stakes have extremely good holding power.
Hikemax Titanium: 6.3 inches, 12 grams, $3
TiTo Titanium: 6.3 inches, 13 grams, $3
(not a comprehensive list)

Shepherd’s Hook Stake
The Shepherd’s hook stakes tend to be the lightest type of tent stake. However, they tend are more likely to spin or bend. Wider tent stakes are less likely to bend or spin, but weight more.
TiTo Titanium: 6.5 inches, 6 grams, $3
Vargo Titanium: 6.5 inches, 8 grams, $4
(not a comprehensive list)

Nail Type Stake
MSR Core Stake: 9 inches, 14 grams, $9
MSR Core Stake: 6 inches, 6 grams, $8
Easton Aluminum Nano Stake: 6 inches, 8 grams, $3
Easton Aluminum Nano Stake: 8 inches, 12 grams, $3
MSR Needle Tent Stake: 6 inches, 10 grams, $3
(not a comprehensive list)
Summary
The most durable tent stake that provides the best holding power in various conditions would be the Y-stake design. However, these tent stakes tend to weigh more than other stakes.
If you want to use the lighter Shepherd’s hook tent stake, you should plan on replacing them more frequently because they are more likely to bend the more you use them.
In general, longer stakes of a similar design will perform better than shorter stakes.
TIP: It is always a good idea to carry a spare stake or two, in case you ever lose one or if they bend or break.