Anything that is "super", especially when it's also "duper".
The "pooper scooper" part is added both for
extra "superness" and "duperness" and for just being plain silly or to make someone who has never heard the phrase before laugh like a silly little
mermaid or guffaw their bollocks off.
"
Wow, have you
heard the Chemical Brothers' latest
single? It's, like, so damn catchy. Like, super duper pooper scooper catchy."