I know you said you're fine with inflatables, but we have an inflatable double that comes up to normal bed height and is pretty serviceable for a temporary sleep.
Mind you, while it gets pretty rigid, I'm not sure it would count as a properly firm mattress!