It depends on your definition of 'famous'. For instance, there is a huge difference between the fame of pop star Michael Jackson, and civil rights leader Mohandas Gandhi. Both, in turn, and quite justly, are famous, even through death, but both for two totally different things.
We've seen everything on the news and heard from gossip about MJ, from alleged molestation to drugs. He is remembered by his music and the things he did, but many people have opinions about him because of these rumors. His fame was from the pop music industry, along with paparazzi and many other hard critiquing reporters.
Mohandas Gandhi is another story, remembered for greatness, and power against the British for freedom of India. Most everything is positive about this man, and will be remembered with others such as MLK jr, and Malcolm X. his publicity and fame came in decisions to lead his country non violently, this came in the form of news reporters and many people who interviewed him.
To answer your question, and to get to the point. Yes. It is good to be famous. The question in turn, however is, what will you be famous for? Your actions speak louder than words ever could, but even if you're just one voice, maybe never even heard with fame, you can still change the world.