Budget
Researched
$
PETLIBRO Stainless Steel Cat Water Fountain (3L)
Best for: most households, and anyone whose cat has chin acne from plastic bowls
The one reviewers keep landing on. The whole water-contact area is stainless, which is the point - plastic scratches and those scratches hold bacteria, and it is the usual suspect behind feline chin acne. Near-silent in normal use, and the parts go in the dishwasher. The real annoyance is that there is no external water-level window, so you lift the top to see how full it is, and it needs to be close to full to run quietly.
Verdict: The default pick unless you specifically need battery power.
Find it on Amazon
Mid
Researched
$$
PETLIBRO Dockstream Cordless Cat Water Fountain
Best for: a fountain that has to sit away from a plug, or a house where cords get chewed
Battery powered, so it goes where the cat drinks rather than where the socket is - which matters more than it sounds, because cats often avoid drinking next to their food. Indicator lights for water level fix the main complaint about the cheaper model, and it is dishwasher safe. You are trading for recharging it, and the running cost of filters is the same either way.
Verdict: Worth the step up only if placement or a chewed cord is your actual problem.
Find it on Amazon
Premium
Researched
$$$
Catit PIXI Smart Fountain
Best for: people who want app alerts when the water is low or the filter is due
The drinking surface is stainless but the body is plastic, which is a genuine consideration if plastic is why you are shopping at all - the hygienic bit is the part the cat touches, and the rest is not. The app is the reason to buy it: low-water and filter reminders are the two things everyone forgets. Reviewers who did not want the app found it hard to justify over a plain stainless model at a third of the price.
Verdict: Buy for the reminders, not for the materials.
Find it on Amazon