I spent four years living in that neighborhood and really loved it; Providence is a really fun town once you get to know it. I'm not sure whether it's in your budget or not, but maybe consider finding a place on Wickenden Street- close enough to College Hill that you can commute easily, far enough away that you won't be overrun by undergrads, and legitimately a fun area in its own right.