NECR is farily active down on the south end of the line - still running 2 trains a day, 608 & 610, both are now based out of Palmer despite what the Railpace article says (I'm one of the authors). They were in the process of changing the schedule around, and moved 610 from being based in Montville to Palmer when the article was going to press. Had to put something in there...
Even now, they're not as predictable as before - more trains outlawing down this way in CT than before.
Either way, traffic on the south end is pretty good - 608 (now Palmer to New London) is anywhere from 10 to 40 cars, and 610 (switcher between Pamer & Norwich), is typically around 20 cars.
They do, however, seem to be a bit power strapped, even with the 4 newly arrived LLPX leasers.
Other than Palmer, I can't think of any really decent place to sit & catch action. Lack of trains kinda forces you to chase. If you do chase, the Railpace article does have some of my favorite photo locations listed.
-Tom