Can a futon be as comfortable as a bed?

Absolutely. A thick, high-quality mattress for futon use can provide the same support and comfort as a traditional bed, especially with proper framing.