I have searched for positions nationwide and there are many traditional CNS positions. These jobs are speciality based. I see a lot for critical care, oncology, ER, and OR. If you don't practice these specialities or are unwilling to relocate then you may want to reconsider. SteveDE- I saw one position for a clinical nurse specialist specific for diabetes at UNC Health Care- Chapel Hill.
The CNS degree provides you with a general background in research, direct care expertise, patient education, staff education, consultation, system leadership, and collaboration. You can go for jobs that are not labeled CNS such as management, staff development, quality improvement, and such. The broadness of the role is a double edged sword. It makes it hard to define what the role is but on the other hand you can make a role fit for you. I love this role because it is broad and it is practicing nursing at an advanced level. That is why I got the degree.
I would advise anyone that wants to diagnose and prescribe that they can with the CNS in some states, however just go to NP school.