Aside from a particular programs noteriety as being good or bad, I think one of the most important things you should look at is their accredidation and the # of students that pass the State Boards.
For example, we have a private university in Pittsburgh that is very expensive and prestigous in general for all majors, except when you look at the Nursing program and see how low their # of students is that pass the Boards and that they have lost their accredidation in the past. You'd be better off going to the local CC that has a much higher pass rate, especially for first timers, and has not lost their accredidation.
If you can't get past the Boards and get the license having the most expensive school on your resume still isn't going to get you a job as an RN.
As for clinical sites, in Pittsburgh I can't really say that there is any difference whether you go to a CC, State University, Hospital Diploma Program or Private College. We have a ton of hopsitals, each with a certain speciality and all the Nursing programs
go to pretty much all of the same sites.