I completely agree, apple/mystery snails are serious poo manufacturers. I've found that they also will devour the algae in the tanks they inhabit. MTS are most effective in the substrate, but seem a bit more shy about cleaning the upper walls and rocks.
I really don't like pond snails, not because of anything good or bad, I just don't like them aesthetically speaking.
Some things to consider before purchasing snails;
1. If you don't want a massive snail population, pond and MTS may not be for you. If you still want them, you need to make sure that you feed very sparingly.
2. If you have predators such as; loaches, non dwarf crayfish, Macrobrachium shrimp, puffers, and others... that will affect what type of snail you can keep.
I've seen some species of Macro shrimp pluck out MTS snails and Apple snails. They stick their claw in just under the trap door and grab the flesh out. My Cherax quadricarinatus would use brute force to brake the snail shell and eat. Pond snails would have no chance against them or any serious predator since the lack a trap door.
Apple snails can be much more interesting to observe. The require a male and female to reproduce, but they do so easily. Just make sure that there is at least 1.5 inches of glass, above the water line. The female snail will deposit eggs in a cluster above above the water, they will drown other wise. If there isn't enough clear glass, the female might put the eggs in the canopy or glass just below the light, which will 'cook' or dry out the eggs.