Some encouragement and a couple examples that I've recently gone through to share...
You mentioned your other potential path was an MSW, so I am guessing you may have come from a similar career background as I have, and I also went into nursing to be able to make a more measurable impact on people's lives. This is my second career and I feel like I have a lot on the line because I have two kids, a mortgage and went down to part time at work to do this, causing financial stress for our family.
There are so many different clinical settings, so I wouldn't give it up over one clinical. For an example, my first clinical and my last clinical have been on the same unit at the same hospital. The first time, I truly hated it, the nurses seemed to either be running around like crazy with a high patient load, or others seemed so burnt out that they were avoiding their patients to play candy crush at the nurses station. This semester (my last) I am in the same exact unit with many of the same nurses- the only difference is that the whole unit moved onto a new floor and they have a lower pt:nurse ratio. It is a fantastic place to be now and the nursing "behaviors" seem so different. I asked the nurses what changed and they said that now on the new floor they have what they need, they are better supported, and they have a lower patient ratio. Its a totally different place to be now. I've been on other floors that felt like the students were annoying and brushed to the side, and then others where the nurses truly wanted to teach and allowed us to learn from them. A lot of it has to do with what pressures are put on the nurses and what the management environment is.
If you can even volunteer somewhere over the summer to see a different healthcare environment that might give you some new ideas. Even if you volunteered at a free clinic or as an activities assistant at a long term care facility, you would get a chance to observe the environment and the nurses. We just did a long term care rotation and there is a done of relationship development, therapeutic communication, advocacy and family interaction that those nurses are doing. In addition to, yes, passing meds as well. But in long term care, the nurse knows the patient so s/he would be there a week later to see that the dose adjustment was causing XYZ change and can advocate for that patient, whereas in the hospital you do not see those longer term changes.
I am realizing that there is so much I can do with nursing that isn't on a hospital floor, that having this will be a huge asset. I would like to work in a hospital, but I am also interested in visiting home nurse, community education, public health, lactation counseling, and there are so many possible roads. I am not a good fit for psych nursing, but you may find a fit there... Basically there are lots of different options and my encouragement would be to explore a few before you walk away from nursing altogether.
Good luck!! If only we all knew what we wanted to be when we grow up, this would be so much easier!