I can only speak from a SE QLD perspective. The Wickham hotel in Fortitude Valley is great if you like the idea of your starfish being smashed in by a large man with a mustache. The Stepp Inn at the Valley 5 ways is good for derros and recently released crims.
The Ox hotel at Oxenford is a Finks (bikie) pub, but not too bad. The Alex Hills hotel is good for getting stabbed or raped.