Sand filters are the best and easiest to use. And the problem is not using one too big, it is using one that is big enough. I have seen SO many that are undersized for the pool. Putting your filter into waste mode to vacuum is completely idiotic. If the pool goes cloudy from vacuuming then it seems obvious the debris is going directly back to the pool in which case there is something wrong with the filter.
Vacuum in filter, then backwash for 2-3 minutes or until the sight glass is clear, then rinse for 30 seconds or so, then back to filter. Always turn off the pump when switch the dial valve.
Sand filters have the worst micron filter rating, then cartridge and DE the best.
Sand is easiest to use, then cartridge and DE the hardest. This includes all the cleaning and maintainence. And you must use them properly to obtain the best filtering, but you know what? I have said this many times and In all my plentiful years of doing pools I still don't think you can tell the difference by looking at the water.