Ideally, more expensive, hard pipe would be used for main lines with flex branching to individual rooms in order to reduce noise transmission but that requires planning at the design stage and good luck with that on anything but a custom build.
Even better is when it's hard pipe AND the ductwork is entirely within the conditioned space (basement and between 1st and 2nd floors), as it is in my house.
No duct work is in my attic. The builder has a sales sheet explaining why their houses are more energy efficient and "No HVAC equipment or ducts in the attic" is one of the bullet points.
I lived in a house that just had the ducts for the top floor in the attic (3 level townhouse, basement plus middle and top floor).
In the summer, it blew hot air for 30 seconds when the system came on.
In the winter, it blew cold air for 30 seconds when the system came on.
Who knows how much the ducts were leaking in the attic...they weren't sealed with anything more than foil tape...
...which brings me to the 2nd bullet point they had, "Ducts sealed with mastic".
Although I think that may have already been a building code requirement by then, pretty sure it is now.