I've been using an Extang Solid Fold for the last 4+ yrs.
https://www.extang.com. Lots of sources sell them.
It will leak a little sometimes, but not much if you pay attention to fit of the weather stripping when you put it on. By a little I mean drive thru a thunderstorm and finding a trickle of water that would soak up with a sponge. BUT - If I have anything in the bed that could be damaged by water I'll put it in a storage tub just in case. When I've found more water its been because I was sloppy reinstalling cover and messed up fit of weather stripping.
I picked the Extang because there is absolutely no parts/pieces/tracks/rails/whatever that have to be permanently installed on the truck. The entire cover can be installed or removed in minutes leaving nothing behind. Also, because I have a locking tailgate and the way the latching hold downs on the cover work the entire thing is locked tight when closed and the tailgate is locked.
Downside that some people don't like is that the cover sits on top of the bed rails, not flush with bed. That's the price for no rails or other mechanisms permanently mounted to hold cover. The cover partially blocks stake pockets so you can't use any rack or other stuff that mounts in the pockets.
I like it. Will remove it occasionally to haul stuff when I need full bed access, but it goes on and off so easily that it doesn't bother. Much, much better than my last cover, which was a steel accordian-folding flush mount system that required tracks installed inside bed (Peragon
https://www.peragon.com/ ). But when I bought the Peragon cover in 2005 there weren't many solid locking tonneau options.