If I were to only play one course in Huntsville, it'd be Redstone Arsenal.
It takes a bit of planning, however. The base is closed to the public, but the local club has an arrangement that their members can escort non-members on the course. They are super helpful about it, given enough...