If you get a sofa bed with inner spring, for sure, it will be firmer than foam ones.
The majority of the time, foam ones are more comfortable to sit, however they are less resilient and sleeping comfort is not so excellent.