Yikes, too bad you didn't go for nursing the first time around instead of investing so much time and resources into another degree. You definitely should opt for a BSN. There is an increasing body of evidence linking BSN-educated nurses with better patient outcomes & employers
are starting to pay attention. Hospitals in most larger urban areas in Texas are beginning to hire only BSN new grads. At this time, this is already true for all
hospitals in the (Houston) Texas Medical Center. If you choose an ADN program, you'll probably end up having to upgrade to a BSN fairly soon - this process is not seamless, and you may end up having to repeat some courses and waste a lot of time.
Nursing is not a "major", it is a program.... big differences in the way that you get in, and the way it is run. Acceptance to a nursing program
is carefully regulated in order to be compliant with requirements set up by the organizations that accredit nursing schools. It is a very competitive process, largely dependent upon your GPA and results of your entry exams. The curriculum is not flexible. Students will be dropped from the program if they fail to meet ongoing requirements (attendance & grades). Acceptance to BSN programs in SA & other large cities is extremely competitive... you may have better luck in other areas of the state.
FYI, "Magnet" is a highly sought-after designation awarded by the American Nurses Association. It is a voluntary program. Hospitals must meet very specific criteria and then apply to be surveyed. The criteria reflect characteristics that have been shown to be beneficial for nurses & patient care.