Well, it's a recent one so you might've read it, but I think it fits your request and it's really, really good, so I'm taking a shot and rec you

It Makes You Desperate (http://rockstarpeach.livejournal.com/114722.html) by rockstarpeach

Summary: AU. Jensen and Jared are in love. It should be sunshine and puppies and sweaty, dirty sex all the time. It should be epic and glorious and sickeningly perfect. And it would be, if only Jensen was interested in men.
This is not the story where Jensen is into women and is only gay for Jared. This is the story where Jensen is a straight man in love with another man and has to figure out what to do about it.

I actually havn't read it yet! Thanks! :D

Beautiful Disaster by thenyxie is on of my favorite stories like this.

http://thenyxie.livejournal.com/548429.html

SUMMARY: Rock Band AU. Jensen’s the lead guitarist in the number one rock band in the country. Justin’s the lead singer, and they’ve been doing this together since middle-school, been together since just after high school. As on top of the world as they are, Jensen’s starting to become disillusioned with the lifestyle and his crumbling relationship with Justin. And then he meets a new roadie on the crew named Jared who’s got a voice like an angel and a heart to match, and everything starts to change.

Wow - you are totally right. That story is amazing! Thanks so much for the rec!

Here is a Sam/Dean one. It's called "Manhattan for beads" and it's written by candle_beck:
http://candle-beck.livejournal.com/113591.html

It meets all your criteria, as far as I can tell. Enjoy! :)