Basically anyone who has left nursing because they were too unhappy or frustrated is NOT the one you want to talk to about venturing into nursing today. Talk to currently-working nurses, look around this website, and that might help you gain a different perspective.
I love my job, I really like the flexibility of hours (I work three nights a week and make more than most people I know working five days). I like that I can work more if I want (or not). I like that I really AM helping people, and making a difference in their lives. I like that I can teach them things that will improve their lives, and that I have been remembered long after they have left my care. I like being a role model for my children. I like using my brain every single day, in fact, every single hour of each day I am working (lol, I use it when I'm not working, but you know what I mean!).
There's lots I don't like, but when I'm totally frustrated with staffing or stupid administrative nonsense, I remember WHY I am there in the first place. I make alot of money doing what I like to do and that's the bottom line. Any job will have you screaming at the wall sometimes, and anyone who tells you they don't have times when they want to kill a supervisor is lying. That goes for any occupation!
It's easy to see why the burnout factor is high. It's a very stressful, physically taxing job, moreso than most. The appreciation runs the gamut from nil to major. Don't do it for that, you'll be disappointed. Expect scheduling disasters and so on, that's part of nursing, too.
But in the end, at the end of the day (or, being fair, at the end of a week) I know I am doing the right thing for my life and my family at this time. Perhaps one day I will feel differently, perhaps I will tire of it all and move on. But I am thoroughly enjoying being "Your RN until 7am"