They are lovely machines to look at. Mine is still quite good (it is pristine). However I only use it if I'm taking it somewhere else mobile where I don't want to use the Macbook Air (the 6,1 still seems faster at a lot of things I do which is interesting).
Otherwise I have a quite high spec 2019 Mac Pro I use majority of the time with a pair of 5K screens.
There are loads of people using even older 4,1 and 5,1 Macs and with various OpenCore iterations, even Sonoma running through OCLP so I suspect the 6,1 will keep on for quite a while in one form or another. The very creative technically minded folks always seem to find a way to keep things going.
Other than that, there is always Windows.