I concur that the benefits of "upgrades" have been a matter of diminishing returns for quite some time now. Even if there's upgrades and features now, I worry that in five years from now, the real value will be "not losing access to your data".I share your staunch aversion to software subscriptions for that reason.
The problem with relying on the Open Source community to fill the vacuum is that there are lots and lots of factors that are involved. People genuinely do appreciate and benefit from ubiquitous access to their data. That's certainly possible with a whole lot of self-hosted software, but those methods require back end resources, a firewall of consequence, backups, and an internet connection that not only has enough upload bandwidth to support these applications, but an internet connection that doesn't block ports 80 and 443. Here at Slashdot those things aren't a problem, and the Synology NAS units (as well as a few others) help to streamline these through things like QuickConnect, but now we've left OSS solutions.
If we're looking at desktop applications, Quickbooks' greatest asset is the fact that every accounting firm will take a
On the creative software front, OSS is still very difficult to acclimate to. GIMP can generally do the job in spite of its suboptimal interface, Inkscape is limited but can do the basics well enough, and Scribus is in the uncanny valley between Publisher and InDesign. KDenLive isn't the worst thing ever, but video editing = patent encumbered formats = OSS license hell. Ardour and Audacity can do the job, but they definitely lack the polish of Audition. Honestly, the best competitor to Adobe is Corel, not Github.
There are lots of places where OSS shines (pick just about anywhere in the server closet - you're crazy to run Windows Server as a router, but pfSense, Untangle, Smoothwall, Endian, ClearOS......). There are, however, going to be areas where OSS just will always play second fiddle to commercial software houses. As my very loose rule of thumb, I've found that the further away from programming a discipline is, the worse the OSS software packages are for it.