Not sure if you'll be checking here, I'm surprised no one ever responded!
I live in the Dublin area and love it - considering when I first moved here I lived in a very, very bad area. Most of the upper 270 outer belt areas are smallish suburbs that are great for families and are not far from any of the hospitals.
I work for OhioHealth, so I guess you could say I'm biased as far as hospitals go. I've literally never been to Mount Carmel, so I really can't say anything about them. I do really like OhioHealth, though, and from Dublin, you can reach 3 different hospitals within 15 minutes of driving, which I really like.
With your experience, I really hope you dont have difficulty finding a job! The majority of the problem is for new grads, because Columbus has 5 (6 now?) nursing schools
graduating nurses every 3 to 4 months.
If you're into cardiac, the "main" cardiac hospital is Riverside (although each hospital has a cardiac unit). Riverside is also the primary stroke hospital. Grant is the key trauma center here, and Doctor's Hospital and Dublin Methodist are smaller hospitals (Dublin is brand-spanking new). The only ICU I've seen was at Grant while I was a student, and even then, it was their Trauma ICU, so I'm not sure if you're into that specialty since you do have a TNCC.
I'd be happy to answer any other questions you may have!