I like a healthy dose of everything.
An engaging narrative, rewarding exploration, combat that makes me think (overall challenge doesn't matter, but did I have meaningful choices to make?), and good music.
Visuals aren't important to me, as I've been playing RPGs since the 90's. But visuals do need to be appealing to look at 40+ hours into the game.