Roll top backpacks are the way to go.
I have 2, one is from Cor Surf and that’s my everyday bag. The second is from Chrome Urban EX 28l, and I use that one mostly for shopping and hauling packages to the post office. Both are 100% waterproof ( tested by me on many occasions), and both have a very simple no-frills look.