RE: Having less support, forcing us to go into this endless cycle of subscriptions and updates, just to get everything working together as intented, getting mediocre improvements in between?
You are definitely right about this. Dev don't want to improve on the existing software. Just release a new one. Which is good and bad thing.
That's why Blender LTS is a big deal. Even if they keep releasing new versions, they will still fix bugs on LTS versions.
RE: I have no idea how it is with Houdini and plugins for example.
Same thing with C4D. But the big difference is the updates and bug fixes of Houdini is much more frequent. So its a moot point. Unlike in C4D, where you have to settle for the problem for months despite being in subscription.