Need Advice on Transferring

I am a current sophomore at SUNY New Paltz. I have recently been thinking about transferring to a college such as University at Buffalo or literally any other SUNY. Don’t get me wrong, I love New Paltz, but I don’t feel like I am getting the college experience I’ve wanted since I was younger. I visited UB after getting in, but it is very far from home (aka NYC) but it has a much more active campus life and better sports/events, basically what I’m searching for. I’m really just looking for advice from anyone (current students of NP that maybe feel the same or opposite, current UB students/other SUNY students) on what I should do. I would love to hear about your experiences at your school and if you like the campus life there and would recommend it. Thank you!