I think a game could be a piece of crap in every regard as long as it just has that ONE thing. That one perfect thing. It could be story, visuals(although more seldom this), gameplay in general, mechanics... literally any part of the game as long as it's incredibly well done.
Of course, usually...