
GL.iNet
GL-MT6000 (Flint 2)
OpenWrt enthusiast's choice; good value, but lacks 6GHz.

Running these analyses costs money. Buy through my links to help keep lights on! I may get a small commission.
I did the tp-link archer AXE7800 tri-band
I had good experience with AX55 (wifi6), AXE75 (wifi6e) and AXE95 (wifi6e with 2.5G port). AXE95 does provide 2.5g port, but just 1. If your ISP is <= 1G, you can probably use 1G port as WAN and connect 2.5G switch to 2.5G port for 2.5G internal network. My 1000 sqft apartment did fine with a single AX55, was more than enough. Even recently moving to 3000 sqft SFH, AX55 at dead center of the house covered entire house.
Yep, a Mikrotik would be on line since a long time... Last one I installed. I opened the quick set page, selected Home AP in roll down list. Filled all the fields, clicked OK, the router rebooted. And everything was configured at once DHCP, DNS, subnet, WIFI, basic Firewall rules, even DDNS is configured with a UID you can use with any other providers. 2 more pages to fill and 3 clicks and got VPN up and running. I configured a TP-Link AXE7800 lately and it was a lot more hard and there's 0 analytics nor any advanced functions, leaving me pretty deceived for a router of this price range. Basically a router with advanced analytics and control under 100$ doesn't exist. Oh wait.... Mikrotik has it all.
Thanks. I decided to go with the Archer AXE7800 which is on sale at my local microcenter for $180. Main reason is that I have a few cameras 200+ feet away in my large backyard and eight antennas would help. Mesh system probably wouldn't cut it since I can't put one over in the backyard.
Just an update. I upgraded to AXE7800. It works quite well and doesn't support my 90+ devices quite well. My current connected 2.4GHz device count is 67 and no device dropped yet.
WiFi 6 has lots of features that deal with congested networks. Very worthwhile. WiFi 6e was worthless to me as you have to very close to the router to achieve the faster speeds. WiFi 7 is still very uncommon. Get another TP- Link router with 8 big external antennas and WiFi 6 (or 6e) and you will be good for quite a while.
I have a tp-link wifi 6e router. Was 100 euro. 2400.mbps connection.

GL.iNet
GL-MT6000 (Flint 2)
OpenWrt enthusiast's choice; good value, but lacks 6GHz.

Ubiquiti
Dream Router 7
Advanced management, but limited Wi-Fi 7 range, SFP+ issues.

Ubiquiti
Dream Machine Series
Comprehensive control, stable for large homes, but slow support.

Ubiquiti
UniFi Dream Router (UDR)
Modular, user-friendly, but tricky advanced setup, poor penetration.

GL.iNet
Beryl AX (GL-MT3000)
Travel king, versatile, OpenWrt, but bulky power adapter.