The ancient Egyptians trained baboons to wait tables.

Source: Isaac Asimov's Book of Facts

I'm guessing just one incident was the end of that idea

This is where my mind went as well. But perhaps we could find better uses like rats trained to drive mini 4x4 solar powered vehicles through a crop stopping at weeds with their little machine and plucking up the weeds all while not damaging the crop.