Its up to you. My wife is a clinical nurse specialist and has a MSc in Nursing Practice. She specialising in Mens cancer.
Me, im a RMN so i decided to do the Msc in Health Management, as Psych is much less specialism inclined.
Horses for courses as we say in blighty.