Being a nurse (LPN, RN without a B.S., or RN with a B.S.) is not such a great thing.
LPNs (licensed practical nurses) and RNs with Associate's Degrees have a difficult time finding good jobs, and the ones they do find are at the low end of nursing.
An RN with a B.S. in nursing can find better jobs, but the work is still tough. You might be on your feet all day, or you might be sitting at a desk in an HMO doing telephone triage for 8 hours, listening to people's complaints, deciding if they need to be seen that day, and (if so) looking at computerized schedules trying to fit them into an MD's, PA's, or NP's schedule that day.
If you really want interesting work in nursing, I'd suggest becoming an N.P. There will be a growing shortage of primary care providers (MDs, PAs, and NPs) with increasing insurance coverage, and NPs will have an expanded role in the new medical marketplace, with more freedom to diagnose and prescribe independently of doctors, at least in some states.
The traditional route to becoming an NP was to get a B.S. in nursing (RN) and then a master's degree in nursing (NP).
Now you can skip the RN part and go from high school or other background to NP. Search for "accelerated" or "fast track" NP programs. Be prepared to pay huge amounts for tuition, as for any college degree.