This is my first post so I thought I'd share my own stand idea. I think the idea is kinda interesting but not super unique since it's just punchy ghost boy with gimmick, but I feel like it fits the theme quite well and is relevant to me.
Psychosocial
Musical Reference: Psychosocial by Slipknot
Stats
Destructive Power: D-A
Speed: D-A
Range: C
Persistence: D
Precision: E-B
Development Potential: B
Abilities
The Stand is a Close Range Power-Type that channels the user's anger into energy. The user has severe anger-based issues that they are learning to control. This anger converts to power and speed within the combat potential of the Stand, however at the cost of precision for higher levels of anger. The scale with which the Stand increases its power scales proportionally to the level of anger the user is experiencing, like a spectrum.
Social Mode
While the user is calm (Social Mode), the Stand is capable of performing precise movements and activities but its power is greatly reduced. This is similar to the precision shown by Star Platinum when removing DIO's flesh bud from Kakyoin, or when identifying the fly in the photograph of DIO, but not as great.
Psycho Mode
While the user is suffering greatly (Psycho Mode), their Stand's punches can be comparable to cannon balls blasting the enemy at light-speed. In Psycho Mode, the punches are comparable in strength to Star Platinum (vs. Steely Dan), and comparable in speed to Gold Experience (vs. Cioccolata). However the issue with this power is that the user is blinded by their rage and cannot meaningfully control the Stand, allowing it to rampage and act irrationally.
The user is actively learning to control their bursts of anger to better direct them at foes and to become more efficient in combat scenarios. It can be particularly helpful if the enemy says or does something that invigorates the user's anger levels, providing an easier way for the user to direct his anger, and thus, his Stand towards them.