I have many friends who attend Stony Brook and their opinions of this school goes both ways. The positive of this school is that it's not too far from New York City and has somewhat of a good reputation in the medical field. But like most SUNY Universities, this is also a party school.
Your child will learn if they have the will to learn. Make no mistake, a person can learn a lot going to Stony Brook, or any other University, it just depends mostly on their own will. I would recommend Stony Brook to anyone who wants to experience freedom yet not to the extent of an out of state college.
This University, for now, still has a respectable reputation from New York City employers. I don't know if this will be the case a few years from now, but give it a go. It's not the worst SUNY out there.