Providence is pretty nice, but very small, so you're never that far away from the station. I usually Uber for the convenience, but you can certainly drive/bus/bike/walk there pretty easily. For figuring out where to live in RI, it's more about what kind of neighborhood you want, and mainly which colleges you want to be close to (they're everywhere). I learned that the hard way when I lived next to PC.