Though I can understand that some people are disapointed that Rudeus didn't become OP at the end, I am not regretting he wasn't OP. It's not like he wanted to be the n°1 magician in the world or something like that. So, at the end, there is no sense of defeat or regrets. On the contrary, he had a very succesfull life : familly, work (how he changed the world he lived in), friends and so on.
I see more MT like a seinen story with more realistic views : a typical shounen hero would go save his friends without thinking of the dangers. Rudi, like a normal person, would hesitate because he knows he could really die, but he will still do it.
At last, I think it is according to the message of the WN : be humble and work together, unlike his previous life when he was an arrogant, selfish NEET.
I'm actually writing something now that would be sort of like a light novel, but in English of course. It would be cool if it took off and people on here read it, but eh, I don't really have too many high hopes.
But I mention this because I'm writing different characters in with different motivations. Rudeus is an interesting, more realistic style. But other people prefer the traditional selfless hero style. Still others, and this is more the route I'm going, prefer a more anti-hero with a bit different motivations.
Actually my MC is more of the selfless style because it's easier to write around that. But I like the alternate viewpoints and will be spending a lot of time on a more driven character that people mention, that drive to be number one.
But one thing I've realized while writing these different characters, and this goes all the way back to the Iliad now even, it's that the likable, selfless hero style tends to become a family man and pull back, creating other priorities in life. The driven character has very little in their lives, that's why they cling so hard and try so hard to be the best at their field. It's cold and lonely, despite it not necessarily appearing so. Exploring that style, a more Achilles style if you will, is to me indeed more interesting.
I think we all have little bits to ourselves but generally we don't commit, and if we do, we do the family style because it's easier to go to, is respected by society and there's a lot of assistance for it. But the dominant/ambitious style, whether it be a young prodigy, a great conquering leader in his prime, or a lone wolf veteran, they all share an incredible loneliness. They are outliers, not part of regular society really, even if they play at it. And so many of them hit the wall and can't go beyond it, which I've written in for a couple of my characters, because obviously they can't all just win and go onwards. Obviously just trying hard and working at it is not enough, and while Rudeus failed in his previous life and just wanted a family mostly and some success, he seemed to just back off really going for it. Although taking on Orsted could be said to have been where he realized his limitations so maybe he did try.
Sometimes though it's also cool to see the guy that makes it all the way to the top. It seems for good writing you have to have someone else that's already gotten there, and your character may or may not make it and displace them.
Sorry for the rambling, guess I'm kind of sharing what I hope are some solid insights from someone that's been working on something similar.
Speaking of which, I don't really have names listed for my characters, good ones anyway, anybody want to shoot a few names at me? lol.