1. The attention and adulation is your drug. I think there's no shortage of people who fall into this category.
2. To convert that fame into opportunities you wouldn't otherwise have; and
3. To convert that fame into money.
Obviously if you're just plain rich then (3) is moot. If you fall into (1) then money can buy you fame to a degree.
So that leaves (2). Wealth will give you many opportunities fame will but certainly not all. Or at least the costs to replicate that are truly ludicrous, like being a star in a Marvel movie, spending a year on the ISS, going to the Moon, that sort of thing.
The way I see it the downsides of fame are significant. I've heard tales from people who worked in media years ago that the very stars who now want the media to leave them alone and to respect their privacy would beg them for stories and coverage just a few years earlier.
I don't think I'd want to be ultra-wealthy (as in a billionaire+). At that point you're almost removed from society. I imagine you end up moving in circles with other ultra-wealthy people that are actually quite small. You risk being a target of the desperate, the criminally minded (fraud, kidnapping, blackmail, that sort of thing) and the mentally unstable.
And really what is the practical difference between having $20m and $2b? Sure you'll have nicer houses and more of them. You may well have a super-yacht at that point. But who cares? I know I don't.
You could say "you would if you had $2b" and maybe that's true. I'm sure I'd buy a nicer place but I think I'd still want to keep a relatively low profile.