Keith Richards talked about how great feeling it was to be a famous musician on tour, once during a visit in my home country, and he also said that he wished for everybody to try it.
So, in reply to OP's question: Yes, I still fantasize of being famous – or rather real famous, and not a local 1960s rock musician, even it was really great fun to escape from a venue, with a horde of screaming teenage girls running after the band...😍
On the other hand, a disadvantage of being famous is that you are always watched and any movement shared in the media – so, perhaps life after all is more fun, not being famous...