Well if we're sharing OC Stands...
My favorite one that I've made personally is known as Sunshine Riptide (after the Fall Out Boy song). It's kinda freaky, being a Long Range Colony-Type Stand initially bound to the User's skin, in the form of some sick-as-hell tattoos. Said tattoos are of a bunch of amber-colored frogs, with silver markings on their backs.
SR's Ability animates the tattoos, forming the "Colony" part of the Stand, and are composed of a semi-solid, inky goo that enables them to slip into virtually any unsealed structure due to Goopiness™. This goo is additionally toxic to humans, with exposure to it causing a numbing sensation and sluggish muscle movement for 5 seconds upon skin contact.
Fortunately, these amphibians are rather easy to dispose of, via using freshwater to melt/dispel the frogs. As you can tell, I took a lotta inspiration from poison dart frogs for this lmao
As for who wields the Stand... honestly idk but they're definitely frog themed, and maybe like. the Hol Horse of their respective story. That's kind of just me spitballing here though.
Ooooooooooo 👀👀👀👀👀
The Froogs (frog goos) sound like such fun and chaos, and every second you are not running They Are Getting Closer