We own at BWV and love it! Yes, it has some drawbacks but then, every resort does. The Luna Park pool does not have zero entry but the splash and play area has a wading pool that is great for little ones. There is continental breakfast available in the Belle Vue lounge in the morning. Other QS foods can be found at the BW Bakery, which I can't imagine anyone calling "nasty" because I find it to be clean and well maintained with a cheerful, albeit very busy, staff. You can also get counter service food at Leaping Horse Libations (the pool bar) and over at the S/D, which is a short walk from the BWV side of the resort. The Screen Door General Store carries a nice variety of snack foods and some essentials like milk, bread, and cereal. Family entertainment includes movies at night on the Village Green, the surrey bikes, magicians and jugglers, and the Community Hall which sponsors a number of kids' activities and games and offers free DVD rentals.
I will acknowledge that transportation to MK is not always the best, especially if you are accustom to boarding the monorail and being whisked there in minutes. Living near a large city, I guess I don't think twice about the challenges of mass transit. They are the price you pay for the affordable way to get around. Disney transportation is generally hit or miss no matter where you stay. I would think that being able to push a stroller to 2 parks instead of folding it up to board a bus would be a plus in any young parent's book.
I don't think you'll even notice the drinking and partying that you're afraid of. Yes, some people drink to excess during Food & Wine. And there may be a few inebriated stragglers walking the boards after Jellyrolls closes. But I spent a week in a room with a boardwalk view and never noticed them. If it weren't for my brother-in-law telling me about the people watching he did around 2:30 AM (he has insomnia) I never would have thought it even happened.