Collaboration. Get talking to interesting colleagues at your own or other institutions. Become a very good Co-Investigator - be prepared to do RA type work as a collaborator. Organise seminars, conferences. Go to seminars, conferences. Get a network active, and supporting you.
But I do find it odd to hear an academic say she doesn't like doing research. It's the only reason I'm in the job - although I'm a good teacher & enjoy teaching. If it weren't for the research I'd go & earn pots of money & only work 40 hours a week in the civil service.
Can you articulate what it is you "hate" about research?
And can you have a good think about the possible connection between your (very harsh) self-assessment that you're "shit" at it, and that you say you "hate" it?
THese 2 statements seem to me to have a connection. It sounds to me as though you judge yourself very harshly to the point where it's not constructive. YOu need to be easier on yourself.
If you were my colleague, I would be probing this, and trying to get you to break down those big concepts: "shit at research" and "hate research" - which bits are the bits you think you're no good at? Which bits are the bits you hate?
It distresses me to hear such distress & self-beating up. it's unnecessary. Just by doing are jobs reasonably well, at the minimum, we are doing very well - academics are extraordinarily hard workers just by doing the minimums required of us. We hold ourselves to such high standards.
I want you just to breathe, and try to break down your feelings into constituent parts (analyse!) to see where there can be gains made, initially in your own mind set and professional self-esteem. It sounds as though you have imposters syndrome times 10!
If you do't want to answer the questions I pose here in MN, that's understandable, but if you do, I'm sure we're all here for you.