Plenty to see in the Sound although dockage and meals will be pricey. One option is to dock at a Brewers' yard and use their 'exchange' plan to their other yards, or to join a YC that has reciprocal privileges.
You need to bear in mind that LI Sound has reversing currents, and they are strong enough to be a major planning factor. Get a copy of "Eldridge" or the NOAA current charts for the sound to see how they will affect EVERY trip, because some weekends you will need to go east and others you will need to go west 'period' unless you are motoring all the way.
Also check out the marine bouy historical wind data, it can be exasperating in July and August to see 2 knots for long periods and 5 only at around sunrise/set.
There is lots to see--you just have to be flexible about where you will go depending on the wx and currents on any given weekend, and if you plan to return "early" on Sunday...that may mean the Iron Genny. Or, a big asymetrical.