I, like many others, am in the "it depends" camp.
On DH and I's first trip together (honeymoon), we had no idea what we were doing. We picked POFQ based on some pictures on the internet and our
travel agent recommended a water view. This ended up being great for two reasons...when we stepped out of our room each morning, we had a gorgeous view of the river calmly flowing by. It also meant that we were in a quieter part of the resort which was great as a honeymoon couple.
After being at Disney as an adult, I had a better feel for the place and we decided on Yacht Club for our next trip based on the pool and its proximity to our favorite park, Epcot. The Yacht Club is pricey and we were there in August, so I figured we'd be spending a lot of time at the pool and thus, we booked the cheapest category room. We still had a nice view of some trees though.
On our most recent trip, my husband temporarily lost sanity and wanted to stay in the Contemporary Tower. We chose the Bay Lake side. I have to say, I really enjoyed coming back to the resort and sitting on the balcony every day. We had an 11th floor room (highest non-concierge) and the view was really spectacular. I'm not sure I'd pay that much for a room at Disney again unless I win the lottery, but I am glad I did it once.
We hope to add some little ones to our family in the coming years, so I'm sure my next trip will be quite different. I am thinking we will choose AKL (which the view will matter...I would only stay there so that kids could have a view of the animals), Poly, BC, or WL (the view would not matter at any of these places).