http://www.tripadvisor.com/Hotel_Rev...Queensland.htm
Brisbane Riverview would probably be the closest decent hotel to the airport. Lots of motels in the surrounding Kingsford Smith Drive area, some alright , some a bit seedy.
For better, Hilton, Holiday Inn etc, you will need to go into the city.