This is also why a lot of people prefer older FPS titles or games like TF2 used stylized profiles of the characters that stand out. In some games, you want interpretation of the game scene to be a challenge, but in most games, you want players to easily tell what they are looking at. Using high contrast / distinct models / distinct animations / color differentiation all help to achieve that.
https://www.dualshockers.com/wp-content/uploads/2016/06/COW-...
http://assets1.ignimgs.com/2014/01/22/capture9png-e9804c.png
http://www.gamesknit.com/wp-content/uploads/2015/09/dust-an-...
But there's a small minority of games that do look great:
http://cdn3-www.playstationlifestyle.net/assets/uploads/gall...
https://www.gamegrin.com/assets/games/hollow-knight/screensh...
https://cdn.arstechnica.net/wp-content/uploads/sites/3/2015/...
I don't think it's fair to put Shovel Knight in your list. Yacht Club Games tried really hard to recreate a NES aesthetics and constraints (limited color palette, sprites, etc...) with careful deviations when it is really necessary [1]. I don't think you'll find more aesthetically pleasant game in the NES library.
[1] https://www.gamasutra.com/blogs/DavidDAngelo/20140625/219383...
http://www.defunctgames.com/pic/review-batmannes-big-1.jpg
https://www.myabandonware.com/media/screenshots/k/kirby-s-ad...
Hence my mention of historical reasons that are holding game aesthetics back. I think making good art requires criticizing your childhood tastes, not following them.