CAT6 officially maxes out at 10gbps. CAT7 can apparently do 40gbps up to 50m, but i seem to recall the cables being fairly chunky
The theoretical maximum of Wifi 7 is 46gbps.
If you buy preterminated Fibre, it brings the cost down significantly (at least in the past, the main cost was terminating them), especially if you get it from companies like fs.com (I have no affiliation with them, and whilst they seem to be the cheapest in Australia, not sure its the same overseas).
OM3 is 100gbps minimum for shorter distances. OM4 is apparently 400gbps up to 150m I think. OM5 is 6x the speed of OM4 (so is insane)