I'm originally from Providence, RI myself - maybe a half hour walk from the RISD campus, and considered RISD myself many moons ago.
It's quite a fine school with an excellent fine arts program. However, it is most assuredly NOT a school that I'd recommend for a commercial photography education. Not at all.
I'd look into RIT, Art Center in (I think) Pasadena, or Brooks (and probably a few others these days) as better choices for a commercial photography program, but I'm not sure a photography degree means that much in terms of the overall scheme of things.
In fact, I'd venture that a good MBA or business education would be far more useful, with some hard core photography workshops as the education for the technology side of it.
And I say this as an RIT photo grad. I learned a LOT there and had some excellent (and likely now retired) professors like Les Stroebel, Howard LeVant, the late Terry Bollman, Andrew Davidhazy and others, and have applied a lot of "thinking how to think" that they taught in my now non-photography career, but honestly, I just don't think a photography degree is neccessary at all in order to be a successful shooter. The business side of it tends to trip people up far more than the shooting side, hence the quandry. However, I had an excellent time there and learned a lot more than just photography that has served me well in the decades since.
-m