My desires are driven by ideology rather than any specific requirement. My needs are met by my Mikrotik CRS328, but I loathe all devices that I pay for but do not own (if I owned it, I could run software of my own choosing on it).
I meant more this: why do you need to manage 48 separate VLANs for a home lab?
I'm not sure where you got 48 from. I need 4 or 5 VLANs. I need a little bit of PoE. I need a little bit of SFP+. I want it all to fit in 1U of rack space.
The VLANs are to keep my network segmented: wan, management, internet of shit, trusted, testing.
48 ports, not 48 VLANS.
In my case, 410G + 241G switch fulfills needs of a home LAN in a typical house/apartment. To have it running some FOSS OS would be a dream.