Music & Entertainment:
* Beck: Mongolian Chop Squad: A group of high schoolers forms a rock band and gains popularity.
* Nodame Cantabile: A free-spirited pianist and a brilliant conductor both rise to prominence in the world of classical music.
* Your Lie in April: A talented pianist overcomes his trauma to rediscover his passion for music.
* Skip Beat!: A girl enters the world of show business to pursue her revenge, ultimately becoming a successful actress.
* K-ON!: A group of high school girls form a light music club and gain popularity through their performances.
* The Idolmaster: A group of young women train to become idols, facing challenges and rivalries along the way.
Sports:
* Haikyuu!!: A high school boy's passion for volleyball leads him to become a renowned player.
* Slam Dunk: A delinquent finds a new purpose in life through basketball, eventually becoming a star player.
* Eyeshield 21: A shy boy with incredible speed is recruited to play American football, leading him to a legendary career.
* Ace of Diamond: A high school baseball player's talent and determination propel him to the top of the league.
* Kuroko's Basketball: A talented player known as "Phantom Sixth Man" helps his team achieve victory.
Other:
* Death Note: A high school student discovers a notebook that allows him to kill anyone by writing their name, leading him to become a notorious figure.
* Fullmetal Alchemist: Two brothers strive to achieve their goals, becoming legendary alchemists.
* Attack on Titan: Soldiers fight against giant humanoid creatures called Titans, becoming heroes and legends.
* My Hero Academia: In a world where most people have superpowers, a boy without powers dreams of becoming a hero.
* Blue Exorcist: Two brothers become exorcists, fighting demons and protecting the world.
* Soul Eater: Students at a school for weapons wield souls and become powerful fighters.
Note: These are just a few examples, and many other manga feature characters who achieve fame in various ways.
Consider what kind of fame you are interested in (music, sports, entertainment, etc.) and what kind of story you are looking for (drama, comedy, action, etc.) to find the perfect manga for you.