That’s a very negative view of Brissie you’ve got there BigNik, and I suspect from a couple of your comments quite outdated. Sure it’s not New York, but you make it sound like a backwaters shithole.
To the OP. Brisbane may not be a ‘destination’ city but it’s a hell of a nice place to live and there’s plenty to do.
Brisbane is a very centralised city, so if you’re staying somewhere close to Lang Park (Suncorp Stadium), you’ll likely be staying in the CBD. Public Transport in Brisbane is decent at getting people into and out of the CBD, but not much else. I would recommend taxi’s for much of your travel needs - if you need to get out of the CBD. Otherwise everything with in the CBD is within an easy walk.
In terms of dining, I’m not sure what your tastes are, but a few recommendations from me;
Fine Dining
Aria - owned by Matt Moran, who is one of the biggest celebrity chiefs in Australia
Restaurant Two
JellyFish - Seafood/Fish restaurant - excellent fresh seafood!
Cha Cha Char - high class steak restaurant - great food
E’cco Bistro - another celebrity chef place - food is just fantastic here.
Pub Grub
If you don’t want expensive and like a nice big steak and a beer, two of my favourite places which are both only a 5 minute cab ride from the city are:
The Pineapple Hotel
The Norman Hotel - being a massive steak place their advertising is Worst Vegetarian restaurant in Brisbane 
There are just tons of really nice places to eat in town, many not ‘destination’ places, but if you just want a nice place to eat, I can give you a long list of places I enjoy.
Directly across the river from from CBD is precinct called Southbank. Amongst other things it is full of restaurant’s of various classes and quality, and is worth a stroll to see the sights. Southbank is also a parkland, and has a beach (yep a beach in the heart of the city) in a closed lagoon type scenario. Southbank is also the location for the Queensland Museum, Art Gallery, the Gallery of Modern Art (GOMA), and a performance centre. Don’t know what you’re into but IMO the Queensland Museum is worth a visit and a look around. Wandering around Southbank itself makes for a pleasant afternoon.
Don’t worry about BigNik’s stinger danger. It’s not something you need to worry about in Brisbane. The furtherest south any stings have been recorded (2 incidents that I can recall offhand) is at Fraser Island which is 300kms north of Brisbane.
If you do wind up staying out at Wynnum, it’s actually not that fantastic to swim at anyway, the shoreline is mainly mudflats. However, there is a man made tidal pool on the foreshore where you can swim, and also a man made beach (with imported sand), called Pandanas Beach, which is nice.
Depends what else you’re into as to what I recommend you can do.
Fortitude Valley has an ‘alternative’ club scene and a thriving live music scene. It’s actually a dedicated ‘entertainment’ precinct. It’s walking distance from the CBD.
If you have a full day spare and can hire a car, I highly recommend either the Gold Coast hinterland or the Sunshine Coast hinterland, both of which make for very nice enjoyable day trips. The sunshine Coast hinterland in particular has become well known for locally produced cheeses, and other local produce. There are various little townships up that way good for a stop and look.
There are three amusement parks 30 mins South of Brisbane, Dreamworld, MovieWorld, and Wet & Wild. As you’d expect they are mainly about the rides, rollercoasters etc. They’re not Disneyland true, but on a scale size, both Dreamworld and Movieworld are each about the size of California Adventure, or the Universal Studios park in LA.
~45mins north of Brisbane is Australia Zoo, which was the zoo established by Steve Irwin. If you liked him. If you like animals, Lone Pine Koala sanctuary is only 20 mins out of the CBD if you want to cuddle a koala.
Maybe it’s a bit of a local thing, but Mt Cootha lookout is nice, it is only 5kms from the city, gives you a great view of the city and out to the bayside. Plus there’s a nice restaurant up there, although a bit pricey for what you get. Paying for the view I suppose!
If you’re coming shortly, you can still get on a whale-watching tour. Humpbacks are transiting to the Antarctic at this time of year.
If you can let me know when you’ll be in town I’ll let you know what special events are on as well.
Hope this helps. If you want to share a little about what sort of things you like and are into I can get a bit more specific.