I don't know what school is best for you. It would depend on what you want. I'm not an expert, don't personally know the schools. Here are some basic facts you should know.
In the United States, a "community college" isn't the same thing as a "college." Usually, a college program lasts 4 years and grants a "bachelor's degree." A "community college" program only lasts 2 years and grants an "associate's degree." In the U.S. we would not refer to that as a "college degree." Community colleges are very affordable, and a graduate may be able to transfer to a 4-year college, do years 3 and 4 at the college, and end up with a 4-year degree.
UConn-Stamford isn't the main campus of the University of Connecticut system. UConn's "flagship" campus is located in Storrs. UConn is a major research university with 18,000 students and undergraduate and graduate degrees in every conceivable field. However, UConn-Stamford is a small branch of that university with 1,300 students. UConn is a public university, operated by the State of Connecticut.
Sacred Heart University is a Roman Catholic university. It is a private institution and it is operated by the Roman Catholic church. That doesn't mean it is just for Roman Catholics. If you happen to be Roman Catholic that might be a plus and a comfort factor. You will probably find that most of your classmates are Catholics. It's not an important decision factor, just something to know.