Fam Camps, base camp grounds, are not, nor were ever intended, for long term homesteading.
They are for recreational use on a short term basis. Period.
You should read the article about cutting housing funds for people like you. Those getting BAS and COLA and living off the cheap in Fam Camps.
The housing situation in the Wright Patterson area is not "bleak." As you say. There is ample off base housing to rent or buy.