Does Soundproofing Foam Really Work?

I have seen countless people mislead into believing that soundproofing can actually soundproof the room from external noise. I was among one of them but not anymore. If you ask me, the answer is Yes and No. Yes, because it works for the purpose it is designed for i.e...