As it's been said before, it's all in the application. Fable 2 was state of the art in many ways, but I still found it unattractive because of how that advanced visual technology was put to work.
On the other side of the coin, The Legend of Zelda: The Wind Waker is still considered the black sheep of the franchise because of it's bizarre and comparatively low-end graphical style. The way those cartoony graphics were put to use, though, created a vivid, living world that remains my favorite LoZ environment to this day.