Cat6a supports 10gbps. That should be good enough for the foreseeable future. Fiber is significantly more difficult to pull through the wall since it is more fragile.
https://toolboom.com/en/fusion-splicer-kit-signalfire-ai-9/
It's not something I'd use to splice a very important cable carrying long haul DWDM circuits, but more than good enough for its purpose.
As to whether a house needs fiber to each room? I'm not really sure, at the loop lengths involved, recent cat6 cable has a high chance of working successfully at 2.5GBaseT and 5GBaseT speeds, even if it doesn't qualify and test successfully for 10GBaseT. If you have a really high end 802.11ax 4x4 dual band AP with 2.5 or 5GBaseT interface on it and the switch to support it, in real world use it's unlikely you'll ever get much beyond 1000BaseT speeds to it with real wifi traffic.