Great post! I don't agree with everything you said, but a lot of the information was really good.
I have ramshorns in almost every tank, and I love them. I have seen them go after my shrimp on occasion, but only if the shrimp are having trouble molting and laying on the sand for too long. They don't bother healthy shrimp. They never seem to bother any of my plants with a few exceptions. They pretty much wiped out my camboba (I have read other reports of this too), and they will occasionally eat younger java fern leaves if they can't find enough food.
Malaysian Trumpet Snails:
MTS are another that have found their way into most of my tanks, though not intentionally as the rams. I have grown used to them, and no longer worry about it. They actually do eat algae in limited quantities, although they're not going to make a significant impact as certain other snails will. I have not confirmed whether they eat holes in any of my plants. If they do, I think it's rare.
Not a fan of these guys. I have seen them eat holes in various plants. Assassin snails love bladder snails more than any other type of snail, which is good. I have also found that ramshorns will rapidly outcompete them and keep the population very low.
In addition to the rams, my other personal favorites are horned bumblebee nerites. Great algae cleaners and not too heavy to clean the leaves of plants. I have had very good luck with them. They're hardy and can survive a wide range of water parameters. I also have three olive nerites that have been workhorses for over a year. I had poor luck with the larger zebra and tiger nerites. They kept flipping over on their backs constantly and couldn't right themselves again. If I was out of town or not paying attention, they died before I could flip them over again. I eventually lost all of both varieties. They're beautiful, but I just don't have patience for high-maintenance snails!
I was hesitant to take the plunge, but I eventually bought a purple mystery snail to live with my betta. He has done a great job cleaning up the algae and hasn't bothered my plants. As I only have the one, I have not seen any eggs or babies, so I'm happy about that.