They can clear up greenwater as well as a UV sterilizer with some current, but after that, they typically starve to death in an aquarium. This can take months, though, sometimes years. To keep them alive, you'd have to culture greenwater and move them into it occasionally so they can eat.
A few facts that came up in a recent thread about freshwater clams and mussels:
If they move, they're unhappy, likely about water quality.
If they're happy, they'll never move, and might even bury themselves never to be seen again.
When they die, they can cause major water problems very quickly.
Unless it's moving around, it's effectively impossible to gauge its health, the first warning you get that it's suffering is likely going to be when it dies.
Really, it's an awful lot of work for a brown, sessile invertebrate. You can pretty much get the same effect and enjoyment putting the empty shell or a realistic fake in your tank.