Re: Arifureta

-the harem
I think they keep the bunny as a fuckbuddy, but the rest of the girls get BTFO'd as bad influence to the children.

-poorly developed trope filled characters, the characters are largely defined by their tropes
The "500 year old vampire loli" archetype is way different from the "confident missus that manages the girls around her husband in order to make him happy" archetype. So, which one of the two archetypes is Yue?

-incredibly inconsistent protagonist
We didn't even see him before the fall. You can say that he doesn't get enough development, but not that he's inconsistent.

-bland story and worldbuilding
The effort at least is non-zero, which puts it above the average for an isekai. This mostly speaks for the low quality of the worldbuilding in the isekai genre. There are some works that put lots of effort in, but the average isekai doesn't really care for the world. Instead, it cares for the main character themselves.

-unnatural dialogue
All of anime is with "unnatural" dialogue.

-awfully executed comedy
Saaa.

-atrocious cgi
Yup. This is the joke. You are not supposed to take the battles seriously.

TL;DR: Arifureta is a comedy, yet you did not like its comedy. This is all you need to say, the rest of the arguments aren't quite there.