Foxwoods is one of the largest casinos in the world (at least by floor space). It's comprised of several different casinos (i.e. Rainmaker, MGM Grand) that are connected to each other, so you have plenty of options where to gamble. If you're a poker player, their poker room is world-class: it's the largest poker room in the East Coast and you'll get all sorts of games and limits there. The crowd is split b/w New York and Boston. There are a few bars and clubs so there is (weekend) nightlife--although they stop serving alcohol at a certain time which ain't cool. You have your standard choices of lodging from the different properties. I usually choose the Two Trees Inn b/c it's the least expensive (although it's a shuttle ride away), and the Bellissimo Grande is another Foxwoods-affiliated option nearby. Just realize that you're in the middle of nowhere out there--there's a reason why it's called "Foxwoods." Could be good if you're into hiking and that sort of stuff b/c some of the views around there are quintessential New England. But it also could be bad b/c if you don't like what you see...civilization is kinda far away. Def worth a visit though.
If you own or manage Foxwoods Casino & Resort, register now for free tools to enhance your listing, attract new reviews, and respond to reviewers.