Nursing is my second career...the same is true for many...welcome to the club!
Good things are a certain degree of autonomy (especially if you become an advanced practice nurse), mind-stretching all the time, and seeing that something you do for someone helps make him or her better...
Bad things include having too many patients to do your job well, intense emotional stress when people are angry or upset, heavy physical work, and management that doesn't see things realistically....
Since you already have 2 Bachelor degrees, I'd say you'd be a good candidate for an accelerated Bachelor of Science in Nursing (BSN) program. Even if you don't go for an offical accelerated program, I bet lots of the courses you've taken will apply, especially if they aren't more than 10 years old. Talk to schools
in which you have an interest, to see what they offer, what they require and what they will accept from your past schooling.
It's important to go to a reputable school, but you don't have to go to an expensive school. I have a bias against online schools, since I don't believe you have clinical supervision that you get through an in-person school. There are many community colleges that have good reputations, but some that aren't worth your time or money. I got my BSN from a local branch of Indiana University. It is a great school. You MUST go to a school that is accredited. Not all are accredited. If the school IS accredited, it will be in their literature because it's important, and something they're proud of (and they know people are looking for it) It's unlikely you could get into graduate school without a bachelors in nursing from an accredited school. Also, you have to become certified after grad school, in order to practice, prescribe, and bill for your services, and that requires schooling at an accredited school.
Good luck! It's a big decision!