if you want to know who's the main villain, its the crown prince of the meltia kingdom, which "surprise", he's the reincarnation of the mc friend who died due to the bullying, the elf big sister also fall in love him, so it seems all of the elf big sisters doing is to help him achieve his main goal
the prince main scheme is to seal every magic in that world and somehow turned himself to god-like being, after he become god he intend to return to earth so he can payback to everyone who has bullied him, so that's right everything he's done is so he can bully back the people who bullied him
in the end due to the mc skil with the heavy arm, he's the only who able to fight the prince (at this point they already know they both are reincarnated person and friend with each other) and mc win due to he swallow his ring thus manage to avoid detection of any attack from the mc and beat the prince with sneak attack
however, the prince is not dead but he really indeed able to return to earth, but the earth already destroyed due to war so there's no one left to revenge for him, at least due to some random girl kindness the prince back to his kindness and decided to recreate the earth using his godlike power and become saviour lmao
the elf big sister with clairvoyance in the end got captured and sentenced to life prison, whoever they cant kill her since she's pregnant with the prince child and there's debate if the elf kingdom should kill her or at least let her take care of the child, she deliver the child safely in the end
as for the the noir group, the princess got her mind reversed to infant again and with monitoring from one of the high member the guild, the rest of the group trying to live normally and contributing to the society, like that lolita girl is actually a pretty decent farmer
the former leader of that girl corps thingy who tried to kill everyone before, finally doing one last final attack to the foundation but got beaten by her former friend and with s-rank adventurer help, managed to subdue her and sealed her in ice for dunno how long (if im not mistaken), at least the vice leader decide to build a tomb for her and keep visiting her
that asura girl also finally got her seal broken and become friend with the mc and help him in their effort
as for mc with her harem, he finally able to wed all of them, including the dragoon inventor girl who is the last to be engaged with him, not before there's some shenanigan with random leader of the dragoon city who want to propose to the inventor dragoon girl, it end up with the dragoon girl cooperating with the receptionist girl to beat the heck out of him, but this result with the dragoon leader fall in love with the receptionist girl, so all is well for them
i do remember the mc finally have some children with her harem, but i become too lazy to read the rest of it, so that's what i remember in the end