I’d go with hand-drawn in general. They’re the hardest to make but usually end up being the most beautiful. Games like Gris, Cuphead, Hollow Knight, etc.
But I think more than which general artstyle is how well implemented it is and the general aesthetic they’re going for. Like, when you say pixel art, it depends if it’s something that looks like NES games and super high level pixel art like Hyper Light Drifter and Owlboy. If it looked like those, I’d take pixelart any day. On the other hand if it’s really pretty 3D like Hi-fi Rush and Guilty Gear Strive, I’d go for that.
So in the end it depends on what’s the most visually appealing. It doesn’t really matter which style the dev chooses as long as it looks good and works well with the game.