10G is looking to be the end for twisted-pair copper.

25GBASE-T and 40GBASE-T were standardized 10 years ago, but there are still basically zero products available with support for it. The datacenter market just wasn't interested and chose to use fiber and DAC instead. Worst of all: it requires Cat8 cables and is limited to 30 meters. This means it can't reuse existing cabling, and doesn't have the reach for many home applications - OPs blog post mentions the longest run in their apartment being 55 meters.

Combine that with the general death of wired networking for home & office use, and it is extremely unlikely the market of hardcore tech enthusiasts is big enough to warrant massive investments into developing some kind of 25G-over-Cat6-for-100m standard.

10G is pretty much the standard for high-end gear these days. This means any kind of future-proof setup needs to be prepared for a future upgrade to a fiber-based technology.