Ultimately, I decided to go to CNM, largely because I had already been living in ABQ for many years, and had other friends in various stages of the program. I figured that nursing school would be a big enough change, w/o moving to another city on top of it. Ultimately, I'm very satisfied w/ my decision, namely because the tuition is unbelievably affordable, and I've met fantastic friends (which has been an unexpected bonus). Lots of us have other degrees and are going into nursing as a second (or third!) career. So, you'd be in good company!
That said, my brief experience w/ SFCC was totally positive. The administrators I talked with were very efficient, helpful, and organized (not always the case at CNM). The only down-side, as far as I could see, is that clinical locations might be a bit more limited, or might require more travel time. In ABQ, you've got plenty of big hospitals at which to complete your clinical rotations. It's nice to have the variety of experiences.
If you've heard anything about the CNM program, what you've heard is probably true. Feel free to message me for more info. if you'd like details/specifics. I'm happy to help. I had good friends who prepared me for what to expect, and that has helped tremendously. I'm currently in the program. When are you planning to apply?
If you're a good standardized test taker, I wouldn't worry too much about the HESI. I didn't study at all and got a much better score than I expected (98). If tests aren't your bag, preparation to boost your confidence/familiarity is probably a good idea so you can ace it on your first try. I didn't go as far as to take the TEAS for SFCC (you're right about that; they don't accept the HESI, just TEAS), but I'd imagine it's very similar to the HESI. Good luck to you!