Mystery snails are fine in tropical tanks. If yours didn't like the tank, there might have been an issue with the water quality (ammonia, nitrite, nitrate) or water chemistry (pH,
GH &
KH).
There are also ramshorn, nerite and a number of other snails that can live in warm water aquariums. Avoid Malaysian trumpet/ livebearing snails because they are a pest species that breed out of control and get everywhere.