you should search for 'storage vps'

some providers have a dedicated category for these nodes _still using_ HDD

most VPS are only using SSD/NVMe (even attached storage) so it will be too expensive as you can see

example time4vps - 1tb storage is ~ 5 eur https://www.time4vps.com/storage-vps/