You left out windows 2000 which is IMO the most important OS as it cemented the future of windows with the NT kernel.
And after a service pack (or two?), could
game. That cemented the future of the NT branch amongst enthusiasts as well!
Vista was bad, really really bad, but the worst part is that it probably came too early.
As with Windows 98 to 95, XP to... Me?, and more recently 10 to 8 / 8.1, Vista was chock full of features and a very different underlying approach that just flat out broke many things, on top of all that just being plain slow for the first few service packs.
Vista
also brought the first mainstream 64bit, that is, x86-64 and not IA-64, mainstream desktop Windows OS. Once patched to parity with Windows 7, there was little to differentiate between the two for average users.
And I still lament the demise of gadgets as well as the sidebar. With ultrawide multi-monitor setups, sidebar apps would be useful today, most especially if Microsoft continued to evolve the API to make interfacing gadgets with more sources of information possible.
But even with 1gb+ Windows 7 feeled much faster and responsive. I recall upgrading dozens of vista PCs to win7 and the performance difference was noticeable.
Patch for patch, at least the last Vista patches next to the same patches for Windows 7, they should be near indistinguishable. A fresh install of a late-vintage Vista build wasn't that bad IIRC, Microsoft just had to cut ties to the Vista name given the baggage it carried. I guess what I'm saying is that there's no technical reason they introduced Windows 7, it was all marketing.
IMO win 8.1 was actually quite nice, we had several pcs at work with it. it's just that windows 7 was as good or even better.
I ran 8 and then 8.1 as upgraded from Windows 7, but I had a shell replacement running too when I started using 8 - I never saw most of what the common misgivings with Windows 8.1 were. To me, they might have just as well been Windows 7, and indeed, they really were, with most improvements rather much under the hood and generally unneeded for most.
Overall, the real stinker was Me, or the 'Millenium Edition' for those not aware. Based off of Windows 98 SE (that is, 'Second Edition'), which was a pretty good base for a consumer OS at the time, Microsoft over-bloated it and managed to ruin what was otherwise a good thing.