I used
www.maps.live.com and put in the address: 10100 S Main St Houston, TX to get a birds eye view. It looks like a fairly nice park. It is close to the 610 loop so traffic noise will be present. There is a 3 or 4 story building running parallel to the park that should buffer some of the noise. It is close to the Med Center.
There is also a brand new rv park called
Advanced RV Park that is almost a straight line drive, 10 miles, to the MD Anderson Medical Center. We have driven by it a few times and it looks nice. There is a PRO Bass shop across the highway from it.
If you need me to, I can drive and check both of them out.