Frisco Hotel Recommendation Needed

[massphatness]

Hoping the BABOTL can lend a hand here with a somewhat specific hotel request in San Fran.

We're going to be in SF 1 night on our way to Hawaii.

We're travelling (and sharing a room) with a budget conscious couple, so we'd prefer a place that has two queen beds to a room as opposed to two doubles.

We want to be situated between the airport and Fisherman's Wharf - preferably closer to the airport.

Not looking to go upscale given the budget concerns of our travelling companions, but neither do we want a dump. And by dump, I mean Motel6/ Red Roof/ Super8.

Grace is looking at the Radisson in Brisbane.

Anything else we should consider?

Any issues with the Radisson?

Thanks!