Cat7 doesn’t use RJ45 connectors, so it’s not useful for residential use. Any Cat7 with RJ45 connectors is fake.

Cat8 isn’t worth it for residential usage, and IMO 6A isn’t worth it either. Cat6 will do 10Gbps. For anything faster than 10Gbps, I’d use fiber.

The one place I’d always use fiber instead of Cat6, regardless of distance, is when connecting to a different building. There’s risks with lightning strikes, ground loops, etc that fiber avoids since it’s just light.