They can be used on FW for powering an under gravel filter. they also provide more movement of the water, not good for plants but useful for fish that prefer more fast flowing waters.
They are more often encountered in marine tanks which require anything from 20 to 50 times the tanks volume to be turned over per hour.