Yeah, I can forgive TP for its misgivings because of the hardware at the time. At the time, the game looked pretty great to me. It won't age as well as something like WW due to the art style.
Out of those three, SS has the most glaring, obvious and concerning issues. I'd also argue that it didn't really excel in any area compared to previous Zeldas. There's not one area I can confidently say, "This was better in Skyward Sword than in every other Zelda."