From what I can tell R7800 is still top router recommended.
Will R7000 be fine too (I believe one can install Tomato Firmware on it also - if one needs to). Though I have one router at home TP-LINK Archer C59 v1 running Openwrt but 5ghz kill the network down. It is running on 2.4ghz. Office actually has R7000
Now - lets not worry about budget - I can little more but not exactly near Turris Omnia price ($334). Little below that is okay by me.
Which router has the works when it comes to performance
Here are few Questions that I have answered for you
How fast is your internet connection?
Internet is at 75/75Mbps but I might upgrade to 150/150 or 200/200 Fiber Optic
Do you need Wi-Fi? *(2.4GHz only, both 2.4GHz and 5GHz?) - 100% Yes to 2.4 and 5Ghz.
I really want rock solid 5Ghz
Do you need Gigabit Ethernet? that would be great if possible.
These days isn't everything gigabit ethernet
Do you need USB ports? How many? USB 2.0 or 3.0? Do not really care about this.
I haven't ever had the need to use USB Ports
How many family members/devices must the router support?
2 at home but if guest comes it can go to 5-7 people
What other services do you want? (Do you need VPN, media server, web server, etc.?)
VPN service is requested - OpenVPN or WireGuard etc
I do download Large data like DCS, MSFS2020 etc. Lots of large data.
I'm a bit late on the thread.. be prepared to be disappointed by openvpn performance. Wireguard should be better if you're prepared to go that way and understand it's immaturity.
I found in practice the R7800 maxed out at about 35mb/sec for openvpn on my full fibre connection. If you want gig level performance you need intel x86 CPU with AES extensions. The R7800 would make a good AP for that though.
The r-pi might well work a little better. I've got one with openwrt but I use it as a travel AP. I hadn't thought of using it for the site-to-site bridge but maybe I'll give it a go myself. I'm not expecting it to great but probably not bad for what it is.
The game changer for high performance openvpn is the intel AES instruction set so that means x86 (but you must check the CPU supports it). Openvpn needs real grunt if you don't want it to be your bottleneck. If wireguard can suit your needs though either should be good enough though.