The "sliding water" wins hands down around here. We had a Petmate for years, and made the mistake of replacing it with a Drinkwell, which Jamie only uses for a day or so after I decide to give it to the cat home.
I've had more luck with the "waterfall" type water fountains. When we had the "water slide" type, 1 of my cats refused to use it. With the "waterfall" type they all use it. We currently have a Drinkwell Original fountain.
I have the Drinkwell original, and the small Catit (bowl type where the water bubbles up in the middle) and I used to have the Catit with the dome. That broke but my cats loved to drink off of the dome, I dont think I've ever seen anyone except Munchkin drink from the drinkwell stream