A tent is only as comfortable as what you are lying on and how waterproof it is.
A large tent that you can stand up in and has a decent sized living area is best for families,, especially when it’s raining but this is not what you’re asking for.
Be careful of reviews too. I bought a Coleman tent based on great review but it turned out to be terrible, it wasn’t cheap either.
Bit of a minefield is tent buying, hope you find a good one.