I think you should factor in where you intend to live/work in Brisbane. If on the Southside, your choice should be Archerfield. If the Northside, you should look at Redcliffe or Caboolture.
One thing you should not be contemplating is travelling any great distance to your airfield of choice on our Gateway Motorway, the main North/South bypass for this city, which is a carpark for most daylight hours and always in peak hours.
While Archerfield is only 10 minutes drive from where we live, I am prepared to put up with its negatives for this convenience. Secure tiedowns are $139-146 p/mth but hangarage is rarely available and expensive. Landings and full-stops will be a total of about $30 per time depending on your MTOW, about half to the aerodrome operator and half to Airservices(0700-1700).