I just thought it was extremely tedious and annoying. There are some that I liked, the MM one was tricky but fun, but generally they are all the same:
Hit button, raise water, hit button, lower water. x1000 it seems
I have to say that my favorite dungeon was probably the dark Hyrule castle from the end of Oot.
I feel like it's just a given that the all water temples are bad but my least fav is the Oot one