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'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.