I think the real thing you have learned is that PC upgrades are largely unnecessary. They are only selling new hardware that is better on paper and they need to create compatibility traps to make you upgrade a bunch of other shit to get that incremental upgrade.

Even still, there are a lot of components that are not cheap that you can reuse regardless of CPU socket and memory compatibility changes. I’ve used the same PSU and case and drives and network card for a decade. That’s all shit I would have had to pay for over and over again with a different type of system.