I mostly use VMware vSphere Foundation in environments migrating from physical to virtualized infrastructures. The second use case is when refactoring the application stack to transition toward a cloud-native architecture, which entails redesigning or re-architecting how the application stack comes together, occasionally combining virtual machines with containerized capabilities.
The intuitive management interface of VMware vSphere Foundation has improved over the years, especially in the last couple of versions, which I find satisfactory. Previously, it was quite clunky, but it has gotten better.
Overall, I am generally happy with VMware's customer support; they are responsive and I have no reason to complain. Whenever I've needed assistance, I've managed to reach the right people, even when it involved them going back to their research or technical advisory teams for answers, consistently finding solutions, workarounds, or permanent fixes within a reasonable timeframe.