"As tight as a camel's a*** in a sandstorm".

"As much use as a chocolate teapot"
"As much use as a concrete cushion"
"As much use as a rubber crutch"
"As much use as a one-legged man at an a***-kicking contest"
"As much use as a haemorrhoid transplant"