I am not sure about waterfall fountains but I am sure they will suit a larger house that need decorative ornaments inside or outside. Some waterfall fountains are also considered soothing walls. I have to agree with that because flowing water gives me that soothing feeling, or that calm and compose feeling.
Alas, the house is not built as comely as those houses in magazine covers. Aside from being old, the present design of the house now will just be consumed by the beauty of these waterfall fountains. Also, there is no space indoor or outdoor to include these waterfall fountains.
But if I have a huge house, the waterfall fountains will definitely be included or considered but I would go with the unique ones. Obtuse outdoor fountain with a ball or an alpine rainforest driftwood fountain are types that are one of a kind.