There was a post here with a bunch of links to some different websites to help you find out if nursing might be the right career for you (like a personality quiz, job descriptions, etc.)
I would personally ignore the negative threads here, not because I think we should all have our heads in the sand about things, but because everyone has different perceptions and ideas about nursing and their job in general. Some people truely get taken advantage of by their employers and of course they will have a negative experience in those cases. And I've noticed that people are more likely to talk about negative things (in general) than positive things, so that can skew your judgement as well.
In my limited experience, so far everything is great!! Nursing school is very tough but I believe it is intended to be that way to prepare you for a challenging profession. It IS hard work, but it is also very rewarding work. I think if you can make it through nursing school then you will make it in the real world. There are a lot of options out here for nurses; if you don't like bedside nursing you are bound to find another job after you gain some experience. It is good money and good benefits, with the ability to make some extra cash working overtime if you choose to. Of course you won't be as rich as an actor or professional athlete, but there are many professions out there that don't pay nearly as much as it should (police officers, firefighters, teachers to name a few, as well as nurses).
I don't think people are "born to be nurses" or they have to be "a special type of person", that is an old stereotype. There are some aspects of personality that lend to making the job a bit easier, but most of those qualities can be learned, too. I think if you have a thirst for knowledge, an interest in science and the human body, and a determination to succeed, you will be a fine nurse