The last time I ate at the Blue Bayou was in February, and we had a water view seat.
Most of the boats that passed were fairly inobtrusive, just taking in their surroundings.
One or two of the boats were filled with teenagers who were very loud and annoying.
One boat had a guy who yelled over to the diners, asking how the food was.
One boat had a parent/child combo that you could hear talking, the kid was pointing out the diners and the parent was saying "no, those aren't real people honey".
So while a water view can add a little to the experience, it can also intrude upon it as well.
Not to discourage anyone from asking for/taking a water view, just want people to be aware that it can be a little disruptive depending on who's floating past you.