There is no perfect stake. For campsites in:
- Beach sand, I use snow stakes. Prefer older SMC extra long ones with no holes, I have not seen them for sale for several years, the newer ones are shorter and have large holes.
- Soft to medium soil, the cheap short aluminum rod type of stakes that come with a new tent.
- Hard ground or semi-frozen ground, have used extra large steel nails/spikes but they are hard to remove when packing up so if I bring them on a trip I bring spares.
- Rock, where I camp on rock there usually is an inch of soil above the rock, put a big cobble on top of the stake where the stake goes through the loop, may need two stakes thru the loop. Have not found a good option yet for rock with no soil overlying it other than large cobbles and line.

A few decades ago, Gerry Sports make a U shaped stake of aluminum rod, no longer available so I bought some rod to make my own. It is about 9 inches long (+/- a few inches) and has two prongs that go into the ground like an upside down U with a radius of about an inch at the bend. I have a couple tents that have high tension on a few of the lines, I carry those homemade Gerry copies for those lines.