This is from a practical use standpoint by the way.
10: The Hand
The potential for this in the real world is amazing. Just the ability to teleport, instantly wipe away any matter at all? This is definitely a cool option and would be my favorite had it not been used better in Part 4.
9: Hermit Purple
Joseph Joestar uses Hermit Purple amazingly in all the parts he has it. It can hack into electrical devices and surpass any system in them, and even take photos from a long distance away! An honorable mention I would like to include here is Moody Blues, whose powers are similar but Hermit Purple barely surpassed it,
8: Killer Queen
Killer Queen is one of the coolest Stands out there. With the ability to blow anything up on contact, control the size of the explosions, create an invincible RC car that blows up, create exploding air bubbles, AND rewind time up to an hour back if one circumstance of your choosing is met? The wheelhouse of this thing is much more than that of a normal Stand and would be unstoppable in real life. Got cleaning up to do? Blow everything up you don't want (you can control the explosion radius beyond the object, so set that to zero) and clean the rest! You never have to put your garbage out, because anything that goes in your trash can is gonna be obliterated! This is definitely one of the coolest powers.
7: The World
I would have The World for its all-around greatness. Assuming it has the same abilities as Star Platinum, catching things before they have the potential to hit me, moving at the speed of light, and primarily being able to stop time is a good package altogether. The World Finger is a nice touch as well.
6: White Album
I wouldn't use it for any of its destructive abilities that often, but rather for transportation. Being able to skate at 80MPH on any surface imaginable is pretty cool. I could also essentially fly with White Album Gently Weeps. It's a cool Stand in ways some people don't see it, and that's why it's number 6 on my list.
5: Harvest
Harvest is just about the coolest a Stand can get without being overpowered. You've got 500 little guys who can scour a city for an item they can carry in 5 minutes. They can also inject any liquid directly into a human's bloodstream, making it a good option if you need to save a person fast. I would likely use it the most in the way Shigechi uses it to move, to have him carry him anywhere at very fast speeds.
4: Kraft Work
Kraft Work is the stand of Sale in part 5. It can stop anything within a certain radius from moving entirely, and build up energy to release at any time in stopped objects. It's basically Neo from The Matrix's most used ability. The general uses for this are just amazing, I could make someone stuck in one place for a few minutes, I could stop a drawer from being opened, I could lock a door so that NOBODY can open it. This would take first place, but unfortunately, it does nothing with the flow of time, and time-related Stands are broken.
3: Crazy Diamond
This is amazing. It is applicable in any situation and can revert someone on the brink of death back to good health. It can make all the lego sets I accidentally destroyed whole again. I can track people down with a trace of them. Undoubtedly the coolest overall Stand for me.
2: King Crimson/Epitaph
I would use this ability primarily to foresee what will happen, but erasing time is good. I just don't like the chaos it would cause if I used time erase, so I wouldn't use too much of it (that's the lawful neutral in me talking).
1: Heaven's Door
I did an essay on this, so I learned a lot about it. I believe this is the best Stand for day-to-day use, as it can literally do anything to anybody or make anybody do anything. It is amazing because of how little effort it requires to operate and use, but how big of a difference it can make. I believe, with the right user, it can take over the world or save it from someone who would. What are your top favorites?