I think the fame is almost always through some for of art or work - written, spoken, performed. People themselves rarely become famous for who they are - it's usually results of their work, be it art, craft, or anything else (even thought these two things cannot be completely separated).
Also the concept of being (not just horse)famous itself is a bit strange - there are countless of people who contribute to the community and we openly more appreciate those whose work became popular. Nothing bad about it. But I seriously doubt, that any of those people spent so much time and effort to reach the goal of being famous in the community - and if they did and succeeded... well... you deserve it enjoy!
The more important question is "How will YOU contribute to the fandom?" or "How would YOU like to contribute to fandom" which is a good goal to focus on. Not everypony has to do so - being just a fan is totally fine and ultimately all the effort of others aims at fans.
From the point of view of the person who sometimes get the spotlight... yeah, been there did that, it's fun, but not a goal. It's a great way how to do some things together, make a show for others and bring the group effort to the new level for everypony. It tingles the ego for sure, but that's part of the show and works for just a short time.
In general, it gives you more options and it's up to you how you use it - if you keep it for yourself, or share it with the community. I prefer the second option