Depends on your age.
Under 30, you'll have fun at College Station or Austin. If you're older, you'll just be a creep scoping out those co-eds at either spot and better served going to Houston.
Houston is the lamest big city I've ever visited and spread out as ****.
An option also would be...