Automatically? No.
But i've seen plenty of games that don't push the graphics envelope in any way be mediocre trash. Some of my most favorite games had good or the best graphics for their times.
I think it just depends on the game. A good game idea poorly executed would probably still be a bad game even if the developers had put less resources into graphics.