I don’t know why this is such a hard combo to meet, but I can’t seem to find anything that suits. I assume there’s enterprise gear that would meet these points, but I’m not sure where to start.
POE is for running a half dozen POE cameras, 3x WIFI6 WAPs, Home Assistant Yellow. I could get away with running a separate POE switch if not for the WAPs (looking at the TP-Link AX11000’s which are 10GbE). I could buy a UniFi XG 6 POE for just the WAPs and use another regular POE switch to give me enough ports, but that’s just getting messy.
The ideal is to have a high density 10GbE managed switch that I can use for both my regular gear and POE gear (I have 20 ports to connect out to plus gear I might run in the rack). If the Unifi XG Enterprise had POE it would be perfect.
Commscope/Ruckus/Brocade ICX7650-48ZP will do it. Be prepared for sticker shock.
LOL @ MSRP $18k. Hope OP is made of gold.
For OP, you may want to consider your 6-port approach, not much sense in putting cameras and a Raspberry Pi on a 10G switch unless you’ve just won the lottery and aren’t telling us. Otherwise that’s just a lot of commitment for “pretty”.