Yes. I have done the trip Bundaberg to Cairns and back piloting my own boat once and a few more times on other people's boats.
For the most part the only things you can hit are things you can see in daylight.
It is too beautiful a coast to be doing overnight passages.
It can be done in easy bites of 50 to 70 miles per day.
Suggested itinary:-
Gladstone to Keppel, to Port Clinton, Delcomyn Bay or Blue Pearl Bay.
Then to Middle Percy Island, a virtually mandatory stop for all cruising yachts. You will know why when you get there.
From there to Digby Island or on to Mackay for replenishment or Scawfell Island.
From there you now enter the Whitsundays where the choices are multiple.
Whitsundays to Bowen via Gloucester Passage is worth the effort.
Next stop is Cape Upstart but get in early and tuck in close.
An early start is best from Upstart as you really don't want to HAVE to go in behind Cape Bowling Green. If you do it is not so bad as the bottom is all sand and if you get stuck in there for a couple of days because of a blow, all the loose and flakey paint on your topsides will be sand blasted off.

If you have started up early from Upstart you should be able to make Cape Cleveland at least if not Horseshoe Bay, Magnetic Island. No need to go into Townsville as Maggy has everything you might need as well as commuter ferries into T/Ville.
Magnetic Island to Orpheus Is. is better than to Palm Is. The anchorage is great and though the resort might not welcome you, at least they will not kill you which is definitely possible if you land on Palm Island which has a crap anchorage.
If you have gotten this far you deserve to be congratulated for now you are entering some of God's very interesting country with many choices.
Hinchinbrook Passage is plagued by things that bite like crocodiles and sand flies and would preclude a visit to Zoe Bay and the waterfall above it.
From there I suggest Dunk Is., Mourilyan Harbour (hole in the green wall), the Franklands, Fitzroy Is. then Cairns.
You have a great trip ahead of you. Enjoy!!

P.S. Stop thinking about it and just DO IT.