@RepresentingWrath you tell me, thie above examples are from written novels. @Assurbanipal_II might be. @Hoshino like the ones that says "Goblin Slayer", a title after killing 500 goblins and the rewards? 15% UP in Crit Hits and 30% UP in goblins shit bricks upon seeing MC? Yes, those exist and I can see why, getting better at something you already good at.
From my experience, titles from games usually add stats complimentary to the build. Unless it is a game where there isn't really a build to make. So, if you make a strength build getting a 'Titan' title that gives even more strength will benefit you.