While I would agree that stylized games tend to stand the test of time more than realistic games, I think the key to this is good art. A game can be stylized, but still be crap artistically. You can also have a realistic looking game that is artistically successful; a game that understands the limitations of the platform it's on and does not try to do things that will end up pushing it out of the realm of believability, those games can also stand the test of time. Examples would be any of the Metal Gear games.
As someone who actually creates art for games, I totally disagree that the tech is "good enough" at this point. There are things that are most definitely not possible with current technology, even when you're not trying to be realistic. There are things that current tech will not allow for even when it comes to gameplay. Also, while certain things are achievable now, they could be a lot easier to do with more memory, better fill rate, faster processors, etc...
Also, as an artist, what if my artistic vision is to be realistic? The current crop of consoles still do not have enough memory to really go nuts with textures that keep up with the (now fairly insane) polygon counts. Why do you think so many so called "HD" games have instances of blurry textures when you get close? Rendering is only now starting to make some serious leaps in games, GTA4 is a great example. However, real-time shadows still end up being very low-resolution, pop-in can still rear it's head, and draw distance could always go further. What about an open-world game like Assassin's Creed where you can go into every building? Sure it would be expensive, and take forever to make, but there will always be companies with the ambition, and tools are always getting better, which makes it faster to create this stuff with satisfactory results.
Anyways, all that said, I think the tech is really good right now, and still has room for growth. I am glad we are seeing so many more games that push visual styles into new and unexpected directions then we did in the last gen.