@johndoe85 - Cool that you're trying to build a 10-gig network, but before jumping into AP specs, it's good to remember the main limitations at play here, namely the challenge of fronthauling enough traffic through a single AP to saturate a multi-gig, let alone 10-gig, backhaul link. It's one thing to slap a multi/10-gig port on an AP and connect it to a multi/10-gig switch; it's a whole other thing to actually saturate the port -- very hard to do in most real-world conditions, even with the highest-spatial streams, three radios and Wifi 6. So, if you get bummed as to why there aren't more 10gig port APs out there, that's in large part why (aside from simple supply chain and/or part cost).
So, I would look to uptick your capacity to 10-gig+
on aggregate, as opposed to individually per AP. The best way to do this is to run as tight a matrix of multi-gig APs as can exist without being too co-interferent (ie. with as low-power and tight a broadcast per AP as possible). This will supply as much high link-rate fronthaul as can realistically fit across your residence, with which to saturate all those fast multi-gig ports at once.
All that being understood, time to look at gear. There are a few Wifi 6 2.5Gb APs in the SMB segments that are pretty good, namely the Netgear WAX610 and WAX620, TP-Link EAP 660 HD and EnGenius EWS377AP. All in the $150-300 range. For 5Gb, you'll need to go to enterprise-class with the likes of Aruba IAP-535 or IAP-555, or Ruckus R750 or R850, each about $600+. I think the best cost-to-benefit tier right now would be 2.5Gb capable switching with 2.5Gb capable APs.
So, hope that helps. Any questions, feel free.