Write their names and I’ll try to explain better what they do
Survivor, Sun, Vitamin C, Blue Hawaii, Geb, KQ SHA, Green Green Grass of Home, Brain Storm, Limp Bizkit, Anubis, KQ Bites the Dust and Wonder of U, Spaghetti Man, Act 4, Tusk Act 4/Tusk Act 4 Victims, Golden Melody.
(Yes, I listed Act 4 multiple times. An "Act 4" was mentioned
here (Lol, post 44.), & I don't know if that's distinct from Tusk Act 4, or "
Tusk Act 4's victims".)
(I'm guessing Sun & Geb are the artificial sun stand & the fake genie that uses sand/dirt from Part 3, respectively, but I'm assuming I'm wrong because my memory is trash.)
For clarification, I have experienced a lot of Jojo, up to the end of Part 6. But again, my memory is trash.
Stands that I think I understand, & my rough assessment of them:
Cream: The vampire's Stand from Part 3 that can eat itself & its user, & can do some combination of dimensional travelling while also being a semi-invisible, semi-intangible moving force of existence erasure?
Vitamin C: Either the chef's stand from Part 4 that can take apart food & reconstruct it to make it way healthier, or the Stand from a different part that inflicts body horror via softening.
Notorious B.I.G.: The one from Part 5 that only activates if & when its "user" dies, & regenerates, & adapts its speed to target whatever's fastest in its range, & was last left somewhere in the Pacific(?) Ocean.
Green Day: Part 5 Stand with the effect in its range that stuff that moves to a lower elevation acquires deadly, destructive, green mold.
Chariot Requiem: Stand Arrow activated form of Polnareff's Stand, introduced in Part 5. Causes mass soul swaps in range upon activation for some reason, later begins inducing body horror (Didn't the turtle grow a 2nd head?) for some reason I don't remember. Has some attack redirection I don't remember the details of where it's true body/weak point is a light behind your own head only you can see??
Cheap Trick: Part 4 parasitic Stand that clings to host's back, inflicts a compulsion to hide your back, & pesters to reveal your back. Revealing Cheap Trick kills host. If host is killed, CT moves to a new host. I don't remember, but attempting to harm CT may only harm the host & not CT??
Anubis: The animate/possessive Sword Stand from Part 3 that is also similarly Parasitic??
KQ (Killer Queen): I think remember this well, it's the Stand of Yoshikage Kira, main villain of Part 4. Turns stuff into bombs. Bites the Dust has some 1 hour time loop system? I don't recall what KQ SHA is.
Hermit Purple: Destroy a camera or other recording device to send a vision of the future to the user? Didn't OP specify no Stand users in this scenario? Oh & also purple, thorny vines.
So how much info am I missing?
Also, so sorry about the super delayed reply!