It doesn't matter where I look to travel it always ends up costing $800-$1200 for only 4 days. Hotels are outrageous, gas is too, then there's food and entertainment. I was hoping for a 4 day trip to San Antonio to Sea World/Alamo - hotel and Sea World alone were going to be around 700.00 (that was on the low end if we wanted to stay at a decent hotel - not a Comfort Inn or such) - that didn't include gas, parking (15.00-24.00 a day), food and doing anything else.
Saying that, I'm not sure what breaking the bank means to you. The Great Wolf Lodge in Grapevine Texas is an indoor waterpark/hotel. It is very nice, completely catering to families. I have never heard any bad things about it. But it does cost around 300-400 a day. A trip to Sea World seems to be a good option too (we just can't afford it right now). I did find a nice hotel that was cheaper for us to stay, but it had no amenities (like a pool/restaurant) - the cost was down to 500.00 for hotel and Sea World.
As far as the babysitter issues, I would never, never trust a hotel/resort to watch my child - that is the equivalent to handing your child over to a stranger and walking away. What training do the people have, what certifications do they have (CPR etc), have they had a background check, are they teenagers? Be careful and do your research when choosing that amenity.
I hope you find something that works for you! Have a good summer.