Great place, small-town feel and strong community identity. MIL grew up there and her mom lived in the same house for 75+ years so we'd visit a few times a year when we'd hit up NYC. Its just a 20-30 minute ride on LIRR so easy commute if you needed. I'd live there without reservation.
Housing is very expensive even compared to other nice parts of NY - after grandma died a few years ago, MIL sold the house for lot value for well over $1mm. But you get all the amenities of a nice community for paying that, everything is clean, generally safe, good public schools, upscale, etc.
As an aside, there's a nonfiction book written about the author basically growing up in a bar on the main street called Publicans - The Tender Bar. Good read. Grandma had her 100th birthday there and her scotches were on the house.