The new version of NoScript is effective in blocking active contents in a website. Previously, it is not very effective because I personally seen fake codec or malicious files being served while NoScript add-on is installed, after loading a malicious page while testing malware links, even without user interaction! Example is here and here. Thankfully, NoScript is updated frequently and become better. It’s not perfect but you can always report any issues (e.g. bypass, compatibility, false positive) at their forums.
Some people find NoScript is annoying because it blocks them in viewing the content. This should not stop you in using NoScript because you can always control what it will block and allow... as easy as 1...2...3!