10G is trivially doable on cheap hardware. You can also go 100G, 200G or 400G over the exact same cable, it just costs a lot more on the endpoints.
If you run anything modern you probably can benefit from 10G at least. A NVME does 8 GB/s easily, it's a real pity to limit speeds to 1 gigabit. And Ethernet past 1 Gbps quickly gets pretty terrible to deal with, so might as well go with fiber then.
Obviously, if something is wrong with your existing cabling, 10g-base-t is probably not going to work either. 10G is probably the limit for twisted pair, but I think it'll hold up as a reasonable speed for a long time.
IMO, if you want 10G just go with fiber, it's less of a pain and more reliable. With twisted pair you may find out that the module overheats at times and the link drops out.
And the benefit is I didn't have to run new cable. Lots of homes have some twisted pair in the wall, very few have fiber in the wall. Homes from the late 90s on probably have cat5 for phone lines.