Scorpio will make your games look even better than Neo will if all the specs are legit. Even 1080p games.

Personally I am more interested in improved mechanics and frame rate more power should bring.

Yes this happens for games developed on PC first, then ported to console, and the high-end console version will be great with little or no additional efforts. When the first version is initially taylored on consoles, instead, PC usuallly receives at launch minor improvements by upscaling and applying higher levels of AA and some other FX, but if the game has a well scalable engine and easily enough moddable game data structure, it can receive major improvements later, both official and fan-made. In this case the pumped-up versions of consoles will allow to start from a higher level also on console-first multiplat games, but this will require higher resources compared to previous console-first games that were developed for less powerful reference HW. Costs shouldn't get out of control, anyway, as even in Scorpio case we're talking about medium-high HW power, but already reached and exceeded by high-end gaming PCs.
Last, but not least, surely this mid-gen upgrade will be better for devs than a gen lasting shorter and an all new gen launch, as the additional effort to keep up with higher HW power will be recouped faster, thanks to the user base already large and not having to start again from zero, and the architecture already well known, not a new one, but just the same upgraded.

I refuse to believe that Windows 10 gives you less problems than your Xbox One. Unless you're one of the luckiest person alive. Plus, I checked - 2 updates for the PS4 since February, 5 for Windows 10.

I'm not running Windows 10 on my main PC, still Windows 7. - Even if I was, Automatic Updates would be the first thing to go, big assumption you made there.
Ironically my system hasn't even had a restart in 63 days, there are updates pending since forever, but if it ain't broke, don't fix it.
Often because my machine hosts game servers, it will not be restarted for months at a time, usually only for hardware changes.

The Xbox One typically has updates on an almost monthly or twice a month cadence, mostly bug fixes and the like, with the big updates being less frequent, I would assume the PS4 is the same in that regard... However that only tells part of the story, the updates for games seem to be more frequent AND larger on console.
And I can't speak for the Playstation 4... But the only way you can play a game on the Xbox One after a game checks and discovers updates is to put the machine into an offline mode, which frankly... Is a perpetual pain in my posterior, on PC you can just ignore the update and not stuff around.

And the biggest pet peeve is how crap the consoles list games, the Playstation 4 and Xbox One have no categorization or sorting and are extremely inefficient, not so much of a problem if you have a couple of games... But I have hundreds and hundreds and hundreds. The scrolling is real. - It's impressive if I have company over though, I guess.