I think the party is over for flume/water rides, seems even the amusement parks are taking them out.
Carowinds has removed all of their now and expanded on the water park. I think SFOG has dropped the big falls ride, but they still have the Thunder River and Log Flume.
The flumes are great to ride, but from what I understand and read on here they are pain to maintain and operate and a coaster is just better.