Where to stay:
The Farmington Marriot.
Any hotel in Cromwell, Ct. I think is OK
Avoid anything on the Berlin Turnpike (aka route 5)
Things to do:
On the Berlin Turnpike there is a little complex with Mini Golf, bumper boats, go carts (you have to cross the highway to get to this part), and batting cages.
http://www.berlinbattingcages.com/ There is also Safari Mini golf up the road on the other side- it is a better golf course, but it is just golf.
Tubing on the Farmington River is awesome, but the youngest is too young. If the older two like this sort of thing I would still bring them.
http://www.farmingtonrivertubing.com/
Mystic Aquarium
http://www.mysticaquarium.org/
Ct Childrens Museum
http://www.thechildrensmuseumct.org/index.asp (good to bring the younger one while the older ones tube)
Rye Playland (this is in New York- a 2 hour drive away) is very fun too- they have a rollercoaster that doesn't stop- you have to hop on while it's still moving!
http://www.ryeplayland.org/
I have never been here, but it looks really fun
http://brownstonepark.com/
Go here to rent canoes/ kayaks and explore the river
http://www.cckstore.com/rentals/rentals.htm
New Britain Rock Cats
http://www.rockcats.com/ farm team for Minnesota Twins
What to eat:
The park food is actually pretty good and very reasonable- more comparable to Disney than Six Flags. Healthy choices available.
I have heard Kissels (maybe Kizzles) right down the road is good, but I haven't been there.
Avoid Luizas Diner right outside the park.
New Nice has good chinese takeout.
There are a lot of chain restaurants on Queen St in Southington- one exit down the highway from Lake Compounce (exit 32)
Truffles bakery in Farmington has the best togo food around and very good breakfast sandwiches, but it is not on the way anywhere except for tubing.