G'day Paul,
Mate i was born in Cairns........ moved away for about 12 yrs from mid '90s till 2007, but have been back in Cairns since then........
Like all places there's good and bad areas......... i live on the sth side of Cairns at Edmonton (Bentley Park) and have found it all pretty good. the road from Edmonton to the city has received some major upgrades just recently, so travelling to and from the city is now pretty much a breeze.
Some of the old suburbs like Manunda, Manoora and Mooroobool have some dodgy parts and generally carry a bad reputation, though upper mooroobool, kanimbla etc are all pretty good.... again in sayong that, there are good families that have been in these suburbs for decades, and can't see what all the fuss is about, and as i've just bought a house again just recently there were some places that i checked out in these suburbs and the streets were all pretty good..... though i ended up buying on the Sth side again.
Don't rule out Gordonvale either, it's about 25 klms sth of cairns, past where i live..... it's an old cane farming town, still has it's sugar mill etc...... if u want the country town feel it's a good little town (good pies at the bakery!)
Then there's the northern beaches..... our local Cape Crusader and Real Estate lord mr McGirr can give you the low down on the North Side, that's his turf, and i'm not stepping on his toes...
I'm actually enjoying living back in Cairns now, our kids are grown up (almost) and the Mrs and i are getting a chance to take advantage of the night life in town, restaraunts etc..... not to mention you are based in the biggest town prior to departing to all things further north....... I reckon the size of Cairns is good too, you can pretty much get anything you want here, and the place is still as layed back as ever.... there's plenty of school options etc for kids, most schools are good, though there's a couple of not so great ones..... which i won't mention on here..
i'm happy to give you any info you want via PM o rhere on the thread, if you have any further questions.....
All the best with ur decision.....
Barrabart.