The good nursing programs are not always near a large city. The school that has the highest passrate near me, is in the most remote location.
As far as being middle aged, I'd say have the students in my LVN program were over 40, and several of them did very well.
I think any nursing program you go to will make you feel ill-prepared. I know when I got my first job I was VERY scared and felt totall unprepared. Many things you just learn on the job, and you'll remember and feel like you know more than you realized as time goes by.
http://www.ncbon.com/LicStat-PassRates.asp
That website will tell you all the passrates for north carolina, hopefully a good one is near you.
Good luck and welcome to the site!