I'm going to have to disagree with you on Sharknado. It was trying to accomplish something specific. It was self aware and knew its audience wanted a ridiculous plot and campiness out the wazoo. I'd argue it was successful in this regard and managed to be somewhat entertaining because of it.

I won't argue that it was designed to be so bad it's good --- but I thought it was just bad and felt anxiety trying to finish it.