Playing through Final Fantasy VII as a kid (albeit emulated) was a great introduction to that dichotomy. The game mixes both 2D and 3D art styles to varying degrees of success, but there's definitely a reason why the game's art direction is so iconic. Looking back on it, all I see is a watercolor, handpainted haze (as opposed to games from the system that haven't quite aged as well, like Metal Gear Solid)