That site has every kind of content. There's a ton of free content but the quality varies widely.
They also have models and sound effects. I have never used them so I don't know how good they are.
I don't know of any sites with .wad files if you are looking for collections and not individual textures.