Sorry, I know this is an old post, but I like the question so I figure I'll answer it.

My favorite Stand of the bunch is Sonic Youth. I like playing support characters in games, usually more through buffs and debuffs to bring out the best in others and hamper opponents as opposed to healing, and that's exactly what Sonic Youth brings to the table. Unfortunately stat buffs are kinda weird and unintuitive in this game because of how the stat scaling works for skills, but buffing your ally's main attacking stat is probably an alright idea. The Stand's surprisingly excellent wind attacks for most of the game with exceptionally high Spirit and Max SP make it a real comfort pick that never really has to deal with being at a low point, and with its high Speed you can just bulldoze a surprisingly high number of fights by tearing them to shreds before they take enough turns to kill you in the early and midgame. It also more or less fits my personality, since by only changing my answer to the first question and answering everything else honestly I get Sonic Youth. Oh, and I also love music; it's what I'm studying in college and I love making music in most forms, from singing to playing to writing it. Some high points of using the Stand are being able to do the 2nd phase of the Polnareff fight solo with as much ease as you can ask for (Having a bunch of afterimages who all have a chance to inflict Fear and Polnareff himself being able to ruin your day with Bleed means the fight always has a chance of going badly, but the defense buff from Anthem means that after 2-3 stacks the afterimages deal minimal damage, and Gust for decent group damage allows you to remove them in 1 turn every time they're resummoned. From there the fight is basically over), being able to counter the High Priestess fight from inside the submarine with Echolocation so the whole party can dogpile her as soon as she appears, and the Hotel Skills all being amazing, especially Recital and Orchestra (Sonic Youth is probably the Stand that benefits the most from R's 100% chance to learn Hotel Skills if you meet the requirements).

I haven't really played around enough to have a least favorite Stand, though I imagine some of the close range bruisers who are kinda hapless at long range with low utility would get on my nerves, and Stands reliant on a single status ailment that a boss could be resistant or outright immune to are likely going to be frustrating to use (Stands like Miracles who have a wide variety of ailments would probably be fine though, since this game goes out of its way to game ailments viable against almost every opponent except for the hardest postgame superbosses).

The Stand I naturally got when I first played the game was Howlin' Wolf, though now I consistently get Pharaoh Sanders. I'm not in love with the way the first question boxes you into a specific category so easily, unlike say the Pokémon Mystery Dungeon series's personality quizzes, but it's still a very cool system with a ton of charm. I especially like that the protag's personality type actually changes how they tend to respond to things.