there is a middle ground where you can get NVMe-optimized networked storage with solutions like simplyblock. It gives you local-like performance but separates compute from storage and gives more options for backup & DR.