I'm reading Zenith at the moment, which I think does it really well.
Ukrainian Red CrossDarn. I remember reading a comic at the library with a super hero family that were pretty much media stars. The story focused on the widow of one of the heroes, largely regarded as the golden boy of the group. After she moves in with the family though, following his death, she finds that they are just as dysfunctional as any media family on TV.
I forgot the name though.
"What a century this week has been." - Seung Min KimTo some extent, this trope has applied to the Fantastic Four since the very beginning. It's been cyclically emphasized, then thrust into the background under different writers ... but ever since Kirby & Lee, the title has played with the "superheroes as celebs" conceit.
"She was the kind of dame they write similes about." —Pterodactyl JonesThe two Astra Furst stories in Astro City - one in Family Album, one in Shining Stars - both do fantastically with the concept.
Usually, DC superheroes are seen as stand ins for gods (or at least revered figures to look up to) while Marvel heroes are seen as misfits and outcasts though I know this isn't always the case. However, it is not hard to imagine superheroes as celebrities with things like endorsement deals, talk show interviews, and TMZ invading their privacy.
This angle has been explored plenty of times by both the Big Two (Booster Gold and X-Statix come to mind) and indie publishers. In fact, that was suppose to be the hook for Rob Liefeld's Youngblood.
What stories do you think did it best?