More for homelab, but a road I would definitely go down if 100gbps service was available to me for $50/month.
There isn't really a point except some people like to push the boundary for fun. Agreed it's not anywhere close to necessary for normal home users. But we don't always do things just because they're necessary :)
I mentioned VyOS won't handle line rate (it'll do ~5 Mpps on average hardware) but there are options like DANOS that will. 10 Gbps is do-able with < $1k in hardware, including the server.
VPP+FRR or VPP+DPDK can handle 100 Mpps/100 Gbps across NAT. And with the new Linux Control Plane in VPP, it's possible VyOS will get support in the future (https://vyos.dev/T1797). They're also considering using eXpress Data Path (XDP).
Again, totally pointless but so are many other things we spend our time/money on.