PCIe NVMe work great for everything. The cost of them has really come down recently. They work extremely well for hosting VMs because you get so much IOPS.
About 5yrs ago we pretty much pushed HDD out the window and went with 100% SSDs. Fast forward to 2023, all newer servers come with PCIe...