It emphasizes the powerful impact or positive feeling something gives you, just like a slam dunk in basketball.
It's a slang term, so you wouldn't use it in formal writing or serious conversation. It's more likely to be used in casual settings with friends or in social media.