As a consultant psychiatrist you would see the majority of your patients for 15 minutes every 6 months to review their medication. The is rarely time to discuss social issues or anything particularly deep - it's often just a series of standard questions to tick off all the boxes you need to cov in the time available.
You'd get to ask lots of people if they hear voices, if they're sleeping, if they're eating, if they're washing, if they're socialising, if they hear commands in their head, if they have generic symptom xyz, if they hurt themselves, if they have thoughts of suicide. And then have very little time to do much more than write down their answer, make an empathetic comment or two, and decide whether you feel confident they will refrain from trying to kill themselves before you see them again.
Plus do initial assessments where you ask people to pour out the worst of their life and their pain for you to pick over, and emergency assessments where people are frightened, distressed, and facing the loss of their liberty. You'd potentially be responsible for taking people's freedom away and/or medicating them against their will.
A clinical psychologist on the other hand would see a patient regularly for longer appointments, much closer together, and work with them on improving their life in some specific way. They don't deal with medication (although you'd have to do a PhD to be a clinical psychologist, I don't think you need a PhD to be an assistant psychologist, and you definitely don't to be a psychotherapist).
Occupational therapists also work in mental health teams. You'd get to support people with the way they live their life and how that can improve their mental health.
Social workers also work in mental health teams. You could be somebody's care coordinator, supporting them with practical things, offering emotional support, being their advocate and the member of their care team who really gets to know them well and understand them. You'd see them every few weeks, you'd attend their psychiatrist review appointments with them, support them with other parts of their life.
Community psychiatric nurses can carry out similar roles, although usually more medical focused and often for shorter lengths of time.
AMHPs carry out mental health act assessments with a view on the more social side than just pure medical, and make decisions about whether to detain people and for how long.
These are all community mental health team roles. Then there's inpatient care, assertive outreach, crisis teams (can't say I'd recommend that as a fulfilling choice), camhs, over 65 community teams, crisis houses, physical health psychology teams (supporting people with their mental health who also have serious physical health issues)...
Honestly, it sounds like you've latched onto consultant psychiatrist as the most well known and obvious mental health professional, but I don't think it's the role that's right for you, that suits what you want from it or what you have to offer it (or your natural strengths).