The issue with >1G ports is heat. A typical 1G port will guzzle up 500mW worst-case already, so quiet aka passively cooled and more than 16 ports is already a rare thing. SFP+ 10G ports need 6-8 times more per port or 3-4 watts. 10GBase-T ethernet because of complicated modulation is even higher with 4-6 watts per port worst-case. Add some management processor with 1-3 watts to that and you'd get 50 watts that would need to be cooled away with a simple hypothetical 10G 8-port switch. The heatsink alone would be huge and heavy, like 30x30cm, so the switch continues to work even in the tropics. So that ain't happening. At some point there will be an innovation like direct fiber to SoC coupling with much less power, enabling passively cooled 100G also at home. But that is 10-20 years out.
If quietness is paramount, your best bet is a 16/24 port 1G + 2/4 port SFP+ 10G type switch.
The next problem is your full L3 requirement. Usually this requires big chips like HP/Aruba ProVision ASICs. Big chips, big fans, not quiet. There is a Level One switch called GTL-2881/57080903 which can do some "L3 lite" i.e. IPv4 static routes. But I would rather do firewalling/routing on a Linux box and get a fanless Dell EMC N1124T-ON with some SFP+ modules for it.
If fanless is out the window, check out some Arista threads here on STH. Those have 40G (dead end - 25/100 is the path forward), sometimes ebay has a steal. Mellanox ConnectX-3 that support 40G in servers.
Not sure where you are getting your power numbers from?
This is what I could find on the spec:
" Power supply voltage defined in the specification is +3.3 V, but there are two maximum power consumption levels: Level-1 (<1 W) and Level-2 (<1.5 W). Level-1 SFP+ does not require a heat sink, and can be built into smaller and higher-density systems. On the other hand, Level-2 SFP+ requires a heat sink. On power-on sequence, Level-2 SFP+ has to be started operating at Level-1 (<1W) and then start at Level-2 after the system recognizes operation at Level-2."
And here is a 8 port SFP+ managed switch at 23W with attachments claimed:
MikroTik
Wecan certainly discuss how *well* that companies switches handle traffic, but as far as I am aware their power claims are fairly close. Yes, 10G copper uses way more power, but optical not so much.
Here is a STH review of the bigger 16 port unit, which can run passively sometimes:
https://www.servethehome.com/mikrotik-crs317-1g-16s-rm-review/ Max power rated 44W, max observed power was 34W. Again, not something you'd want to use as L3, but as a L2 switch it works basically at line speed.
Edit:
And as for 40GB being "dead". As clearly pointed out by the discussion in this very thread, even 25GB has a LOT of caveats for a home/smaller setup. And any fiber you run for 10/40GB is going to be compatible for 25/100GB that uses MM, even down to OM2 if the distance is short enough. 40GB transceivers are *cheap* at this point, around 10 bucks or less if you don't care about brand. 40GB Cards are cheap too. And if you need to in the future, there are optics which can do 10/25GB or 40/100GB so you could later interconnect 10/40GB equipment to 25/100GB equipment even without native (Q)SFP+ ports.
I did my research before posting, but maybe somebody is aware of some hidden gem.
