I'm a first-year at P&S living off-campus and would be more than happy to discuss the neighborhood! In short, I love it, even though it has a couple downsides—major one being that it's hard to get to all my friends and concerts in Brooklyn… Great Spanish-speaking area, nice groceries and neighborhood stores instead of big-box ones, a cool range of restaurants, the A and 1 fly downtown fast enough to hang out regularly on the west side. It's totally safe, you just have to use common sense. There are gorgeous parks and views of the river up here. It's particularly perfect for people who are only 50-80% on living in "Manhattan" but who want quick access to a world-class city.
The no-revisit thing is a real bummer!!! Coronavirus is sweeping the island and I think the undergrad campus in particular has been scared into making sweeping pronouncements for all the schools.
This year I haven't been checking SDN much but would be happy to answer questions for people who wanted revisit as a chance to evaluate their culture-fit. Might be able to wrangle some classmates too. Personally, I didn't go to any of those revisit weekends, since I was working on the other end of the country and was only into one school by March. For all the waitlist people: I was WLed at Columbia! This process is crazy, it all shakes out eventually and any med school will offer you an incredible education. Stay strong.