The only song I can think of at the moment with this sort of theme is the song 'Rise and Fall' by Craig David in collaboration with Sting.

But as the song title suggests it talks about becoming famous and then finding that it's not all that great.