New 'old' Macs are great, until you realise that Apple refuse to update Macos if the model is too old. I have a 2012 Mac Mini, the only version they made with a quad core i7. Until the M1 came out, it was the fastest Mac. But I can't update Macos, for no other reason than Apple have decided thus.
The EU directive for everyone to use replaceable batteries and USB C cables is great, but I feel your pain about soldered-in memory and CPU's.
I've just bought a new laptop for travelling, an HP 820 G4. It looks quite a lot like a Macbook 😄 I chose this specific model because it was the last version where you could have 2 internal SSD's, an M2 and a 2.5 SATA. After this , they dropped support for 2.5" drives, which is fine, if they think it's an obsolete form factor. But to then *only* have a single M2? Prime example of backwards progress.