I went to the Connecticut DEEP web site to look up what kind of state parks are available in CT. Unfortunately, the web site does not give any information about the specific camp sites (like Indiana DNR web site does). Looking at some of the campground maps, I can see how they might be smaller sites. This is not true for every park or State Park, and definitely not true for states outside of CT. If your only camping will be inside CT, then I strongly suggest you go visit a couple state parks. You may have to pay an entrance fee, but if you go to the campgrounds, drive around and evaluate the size. You may even take a tape measure and measure off a few to give you an average. This will give you a better idea of what is available. You could also call the park office for the same information too.
What I'm saying is, if CT is the only state you will be camping in, yes there is a possibility the sites are small. But if you plan on venturing outside CT, I don't think you'll have any problems at all with the size of camper you are considering.
Go visit some State Parks and get real world information before purchasing that RV. Consider this as one of those "steps" you need to complete before you make your purchase, to determine the appropriate length of camper you can live with. That is really the only way you'll have your best answer.
But if you ever venture to Indiana and stay at any of the State Parks or State Recreation areas, you'll find sites quite in abundance 50 feet plus!