It is difficult to make a single wall tent keep the rain water out but still breathe. I've done a lot of work with the Maggiolina's fabric through the years, it has a DWR finish (durable water repellant) but even it's finish does wear out with time.
Here are some thoughts, they are highly subjective and always subject to change.
I'm not a fan of seam sealant, it too wears, best to design a tent so the seams aren't in critical places. You will sometimes find seams on the folding rooftents. The good fabrics for this type of tent have a cotton content, which is good because the water causes the fabric to swell and close up to be water repellant. The problem is it stretches the seams, allowing water to come in there. We redesigned AutoHome's OverCamp tent many years ago because the fabric was reinforced at the peak, for wear. If it rained over 4 inches an hour, the tent would develop drips at the threads, even though this wasn't a seam. None of the OverCamp or OverLand tents have seams in the roof for this reason. We also use a "winter hood" that turns the tent into a double walled, four season tent, for these conditions.
Here is what I recommend for the Maggiolina which uses a special Drylon fabric. Drylon is a synthetic polyester, so it doesn't absorb water and swell. With time, the DWR finish (durable water repellant) will wear and water will not bead up and the fabric will get wet. The Drylon needs the DWR renewed. There are several products that can do this. Scotch Guard by 3M tends to attract dirt and dirt hampers the DWR finish. I recommend the 303 finishes over Scotch Guard or NikWax for this reason. Clean the fabric really well, 303 has a special cleaner for this. Apply the 303 finish, and leave the tent out in the sun on a hot day. This is critical, the heat will let the 303 finish bond to the fabric. I will use a hair dryer in the winter, but it doesn't work as well. The Maggiolina's design is excellent for continuous wet weather, but you can also get a winter hood to make it a double walled tent.
The Columbus is something of a hybrid tent. Drylon isn't as good because the sloping walls need more water repellence. This tent uses Airtex fabric, which has a special PTFE finish, similar to what GoreTex now uses. Pasquale is right, it doesn't breathe as well, but you never have to worry about water coming in. I have noticed some condensation in very wet cold conditions. If this is a concern, again, use a winter hood and turn it into a four season tent.
Martyn brought up condensation. This will occur anytime there is a cold surface that warm moist air can condense on. Solutions are breathable fabrics, and insulation. I've seen rooftents that are "waterproof" that will turn into little rain forests once the water condenses on the fabric, not pleasant. Any surface that gets cold needs to be insulated. Many rooftents have plywood bases, sounds bad but actually insulates quite well. Look under your mattress, if it is wet, you tent probably didn't leak, that's condensation. A good rooftent will have an insulated base. Another of my pet peaves is ridgepoles that aren't sheathed and insulated. Fine if you camp in the desert, but water will condense all night and drip on you, even if it isn't raining.
Oh, Pasquale, you mentioned an awning for a Columbus, yes we have them, we use a parawing design that goes over the whole tent, lots of protection, you just attach to the top and it deploys when you open the Columbus, Mike can set you up.
Almost forgot, we have a new experimental mesh that goes under your mattress. It is about a half inch thick and acts like a box spring, has a little cush, very little weight, but allows air to pass under your mattress. Our guy in Germany developed it and I've been testing in in marine conditions, it works. Stock is really limited but we do have some. Should work on any brand of rooftent no just AutoHome.
Hope this helps explain some of the science and design issues. Rooftents are a challenge they are very different from ground tents.
Rich @ AutoHome