The Cheap 10GbE Switch Buyers Guide
servethehome.com
servethehome.com
In the case of the CRS312, its potato-class CPU means that even NAT at 10Gb/s can be challenging. However, if you pair it with something like a CCR1036 (discontinued, but still available and sporting a 36-core CPU) or its successor, the CCR2004 (or even something like the RB5009UPr, which adds PoE, but is limited to 2.5Gb/s) you'll be all set.
Once you run into limitations there (which can already be due to something like "needing to use VLANs"), it's all CPU-based, which isn't necessarily a problem (the amount of switching performance you get out of a Tile-based 'router' is pretty amazing).
The most interesting piece of documentation about any piece of Mikrotik kit is the block diagram, followed by close reading of the L2/L3 offload docs...
"Will the hardware offload actually do anything useful?" is a time-honored Mikrotik game: see the sometimes surprising limits at https://help.mikrotik.com/docs/display/ROS/L3+Hardware+Offlo...
Can I do 2.5GbE to something like the Unifi WiFi 7 AP, again with VLAN trunking?
I have a router for routing (Protecti box running OPNSense) and besides faster access between a high-speed AP and my storage servers, I might also just want to connect my desktop and NAS, as well as have a high-speed link over copper say to my living room where I might want to put a 1GbE switch with 10GbE uplink for the various devices beneath the TV to connect back to the storage servers etc.
I want to do this with as few additional devices (preferably no more than a single 10GbE switch in my network cabinet, a NIC in each device and one more switch for the living room; I already have a bunch of 1GbE switching in a mix of PoE and non-PoE in Ubiquiti EdgeMAX equipment), and as little power use as possible.
Their used 100gig on ebay are surprisingly "affordable".