These are all a little broad. Hand drawn like darkest dungeon, Hades, or like Cuphead? 3D as in realistic or low poly?
Art style should go hand in hand with game thematics. Celeste’s precise platforming goes well with it’s pixel art style, and if they made another version with very high fidelity 3D graphics it would likely hinder gameplay. Likewise, Hollow Knight would lose much of its charm if it went 8 bit pixel art.
All that being said, low poly art can look really good but can also feel really cheap. The same for low bit pixel art. Those aren’t deal breakers for me, but if I was judging purely based on art direction, I would (probably) vote those out.
Edit: Almost forgot, I’d probably lean towards hand drawn for most desirable as it can look very, very good and is usually highly unique.