DH and I always go to BB for dinner when we are in DL. It's one of our traditions. Yes, the food is expensive, but if all you want is the atmosphere and to experience it, go for lunch. It's not the same menu as dinner any more, which means you can't do what we used to do and book the last lunch reservation so we could have dinner at the lunch price, but the monte cristo sandwich is amazing, and it's cheaper. Remember that I said cheaper. Not cheap. It's still Disney, after all.
As for the question about the water table, I don't really enjoy being right on the water anymore. One table back is perfect. Some people are just kind of rude now when they are riding in the boats.
Oh, and be sure to book early. It's a pretty small place.
Have a great trip!
Sassy