(updated June 2024)
The APs in this list are ordered from highest to lowest performance. However, unless you have an insane amount of devices you likely do NOT need to buy the most expensive, highest performance AP. You can also check Ebay for deals, especially on older equipment. In terms of best price-to-performance, the U6 Pro/Mesh/InWall series is the sweet spot in my opinion and is the best choice for most deployments.
All APs in this list support both wired backhaul and mesh modes. However, wired connections are strongly recommended for better performance and reliability.
Number of spatial streams are listed in order of 2.4GHz, 5GHz, 6GHz.