Just a thought , Don't count out the private club options ... Houston has very low initiation fees ... If you are anywhere near Magnolia Creek , check out the Cannongate @ Magnolia Creek option.
Timber Creek is also an excellent option as well for public.
Somewhat downscale from MC & TC will be Southwyck and Clear Creek.
I am biased in favor of Magnolia Creek (original golf development / management company / partner ) ... If you like hard and fast , challenging green complexes , fast Tifeagle putting surfaces , all the length options you every wanted , great mix of 27 holes , wonderful practice facility , nice people ( ask for Matt Stano ) , You'll love Mag Creek .
Having said that , I'm also biased in favor of the north side ... I'm @ Kingwood CC were you can pick an option of anything from 1 course in off times , to full golf on 5 courses.
If you can stand the heat , there are lots of options in H-town