It's certainly worth trying, imo. You can always disable or completely uninstall it if using it really drives you nuts. But if you're at all technically-minded, using it really isn't a big deal. After a couple of days of trial and error, it becomes pretty obvious which scripts are "necessary" for basic site functionality and which aren't. You can either whitelist the former, or just get used to picking them out of the list and temporarily allowing them as necessary (that's what I do.)
I do have the main domains whitelisted for a fair number of sites that I use often and more or less trust (I never do stuff like play games on Facebook, though). And just as importantly, imnsho, I have a number of domains "blacklisted" ("marked as untrusted") - like doubleclick, google-analytics and similar tracking/advertising sites/scripts that in my experience never interfere with the basic functionality of any site. (As "untrusted" domains/scripts, they're always disallowed and you don't even see them in the main listing, though you can access them easily enough with a couple more mouse clicks if you change your mind.)
For ordinary browsing, it's very, very rare that you'll have to allow everything on a page, and even if you do, it's nice to be able to do it on a "temporary" basis with a single mouse click, which NoScript provides as an option, and then equally easily allows you to revoke all the temporary permissions with another single click.