Like most places downtown, the rooms at the Four Queens are not luxurious, but certainly comfortable and clean, at reasonable prices. The hotel started out small, but grew in fits and starts, including the addition of a large tower in the 80's. Standard rooms rooms in the north tower are smaller and more worn. If they give you a choice, go for the reprtedly nicer and larger South tower rooms. Either way, the rooms are average or smaller.
Bathrooms are cramped.
The mini-suites beat the regular rooms by a bunch, and free upgrades are not unheard of if you ask very nicely. Slipping the clerk a twenty will help even more. Ask for a room above the fourth floor or the infernal Fremont Street Experience will keep you awake all night. The South Tower is farther from Fremont, too. You're getting the standard downtown treatment at the Four Queens, meaning they expect you to be an adult and do most things for yourself.