I've had and used several types over the years, as well clam shells and the like. Currently, the truck bed is bare and I intend to keep it that way as it's the most useful to me.
In my experience, any type of fabric cover will sag and puddle rain water, making it sag and stretch even worse.
The setting of bows and snaps, as well the time spent rolling and bundling such a top results in it being left up at the front of the bed, ignored, most of the time.
Anything cover bunched up at the front of the bed will get crushed by tall heavy objects slamming into it, especially when braking hard and suddenly.
Covers that have tracks down the sides of the bed will get the tracks smashed and made inoperable by tossing things over the side, and missing. These covers are also generally impossible to get to slide closed from the side and require either two people to pull it back to the tailgate, or require you to get into the bed and pull from the center.
Light weight covers, even ones that can be carried by little girls, as evidenced by their advertising photos, are darn awkward and a lot harder to get on or off in real life than imagined. This results in the cover being kept in one state or the other, not both.
They all leak. It's only a matter of degree.
Fabric covers tear easily. Be it a vandal kid or the things you drop in the bed that catch it when it's rolled up at the front.
Being able to lock the bed with a solid cover like a Leer or such is kinda nice when road tripping. The suit cases will be wet, but out of peoples eyes. They will all slide to the front of the bed, requiring you to knee walk your way up there to get them, but ok.
Having the likes of a hard cover on the bed will cause you to find wonderful treasures for free that you cannot carry home because they will not fit. Running home to take the cover off and come back only ensures the guy with the open truck has already gotten it by the time you get back.
Running the bed open means you never find treasures like you will with a bed cover on.