advice from someone that owns it:
Pros:
it increases humidity and keeps it very steady
Looks cool in the tank
Really helpful when the snake is trying to shed.
Vibrations are pretty nonexistant if you set up the pump correctly and keep it full with water.

Cons:
The only one I can think of is cleaning. Not very easy to do and to keep your snake healthy, u gotta have a clean environment.

Other than that it is a pretty good buy

I have the Exo-Terra Large Waterfall.