I like Columbus. I've lived here on and off for most of my life. I always seem to come back here
I personally like Riverside, but I have most of my experience in the L&D/Perinatal/NICU areas as a patient/parent. I currently work at Children's, which if you want NICU, is the place to be (though Children's administrates Riverside's NICU) Grant is also a good hospital for trauma and such, but it is downtown.
As for living, it largely depends on whether you have kids or not and whether you'll need schools and if there are any special needs involved. Most of the north side (anything above Campus - Clintonville, Worthington, Westerville, Dublin, Lewis Center) are decent and have good school systems (except Clintonville). Bexley has fabulous schools, but insanely high taxes and very expensive homes. There are good parochial and private schools in the area if you want to go that route and live in Clintonville, Sharon Township or some other area that has Columbus city schools. Avoid the south side, unless you are moving to German Village....even then, I'd say avoid the south side. Typically.....avoid the west side too. Hilliard isn't too bad, but it's struggling with growth issues.
I love working at children's. It is in a bad neighborhood, but they have excellent security now (though sadly was not always the case
) and you should never have to walk from a parking lot to the hospital - they encourage the escort van or going in groups. The area in general is improving due to urban revitalization as well.
I've rambled enough, but Columbus can be a good place to live, IMO.