Can be used when something is really good or more often used with a sarcastic undertone as something bad.

Can be contrasted to words like ‘wet wipe’.