Yes, you're right on the money. If you check out the full credits for The Witness from Love, Death & Robots, which
LileathMia specifically referenced, you'll see that there were 29 people working on the art, visual effects, and animation alone. Even with all those people, the end result was a 12 minute one-off animation.
That isn't to say that it was wasted effort - the episode won something like 3 Emmys for its animation - but to compare something like that with the amateur work of porn games where the development team typically consists of one person, and usually no more than a few, is imo asking for too much. I can understand not liking the samey look of the majority of 3DCG games, but with the current state of production tools and available assets, it's just one of those things that we have to live with.