SFNE is a great park the theming is very good compared to other SF parks. and then there is SROS which is the best out of the 3.
Canobie looks very nice according to videos and photos I have seen of the park. So I dont know much about this park.
Lake Compounce just has Boulder Dash pretty much. Like SFDL just as SROS. I would go to SFNE, if you want thrills, theming, and great rides.
-------------
Top 5
1.) Beast 2.) Phantom's Revenge 2.) SROS (SFNE) 4.) SROS (SFDL) 5.) MF