Did it turn out to be the crinkly stuff? If so, over time, the finish wears out and its noisy.
How waterproof do you need it to be? I've got kayak dry suits made from coated nylon and GoreTex that withstand submersion.
My tarps are all made from coated nylon and silnylon and keep me plenty dry. If it sheds water and doesn't drip through, you're good to go.
Cotton canvas tents shed water fine, got wet, even dripped if you disturbed a wet tent with your finger during a downpour, but still kept us dry.