Why not split the difference and do both. Hdd for storage and SSD for services/containers. To help with the power load/performance hit I’d recommend using a usb to sata adapter that has external power. Overall though it sounds like a micro optipl x would be great for you. They’re cheap, more powerful, but still sip power, and usually can fit nvme and 2.5" drives together.
Why not split the difference and do both. Hdd for storage and SSD for services/containers. To help with the power load/performance hit I’d recommend using a usb to sata adapter that has external power. Overall though it sounds like a micro optipl x would be great for you. They’re cheap, more powerful, but still sip power, and usually can fit nvme and 2.5" drives together.