In our production environment, we use fully automated DRS with properly adjusted migration sensitivity.
Mission-critical VMs need steady performance and automatic load balancing during busy times or host problems, while manual changes just add delay and risk.
We do use anti-affinity and host affinity rules for key workloads to keep things stable.
Overall, full automation gives us better uptime and less manual work without hurting reliability.