How funny, I was just thinking about starting a similar thread
. I believe:
I would Die 4 U by Prince to be about Stevie.
Stevie Baby by Dave Stewart
Don't Come Around Here No More by Tom Petty is inspired by a Stevie incident.
It's Only Love by Sheryl Crow
Malibu by Hole/Courtney Love
There are more I'm forgetting. And I'm sure plenty we don't even know about.