I just joined this site. I've been mountain biking for about 5 years. Have been doing XC ever since then, and I started freeriding in the last past year. I ride every weekend at the Pequonuck River Valley trail area in Trumbull, CT. You'll find some of the best stuff there. They got from little 2 foot drops to the 30 foot ones that scare the crap out of ya. Any riders from CT or around the area? Where about?
West Hartford is kind of flat (after a couple miles of early climbing), but a good mix of moderate to semi-technical terrain. It's heavily used though, and the trail wear is very obvious. NEMBA does a good job of maintaining it though.
Middlesex is super-technical. Lots of quick ups and downs, lots of slickrock, and very taxing on the legs. Very easy to get hurt at Middlesex if you don't watch yourself.
Cockaponset is great. 30 or so miles of tight singletrack. I stick to a 10 mile loop. Lots of rock gardens, logs, stream crossings, log bridges, and short, steep climbs. It's got some of everything. And it's out in the middle of nowhere, so there's a good chance you'll see no more than a few other riders out. The trails are in great shape.
I'd love to check out Trumbull some day. Like I said, I'm more of an XC guy, so don't expect to see me doing any 30 foot drops.