I prefer 3d just cause they're generally the same in quality, but of course there can be exceptions both good and bad, while hand drawn stuff really depends on the artist and can sometimes ruin a game
The most important thing for me is the realism of the characters in a game, realistic proportions to be exact. If it's cartoonish or Daz 3 ish is not so important.
3D is trickier to make look right, in my opinion, while with 2D you have a lot more stylistic freedom, there's less of a risk of hitting the uncanny valley.
If it's good nothing beats 2d, and there lies the issue. HQ animated 2d stuff is very laborious to make, here's hoping AI can streamline this process in the near future. And not only for porn game smind you, this also goes for animation in other media, imagine getting 1 to 1 translations from manga to anime or books etc.