I have a exec level role after having done middle management roles for a while, but I think I was probably happiest when assistant to senior people - making myself "indispensible" to them, having the answers and being on top of things, solving all their problems, but not actually holding the responsibility.
In this role I'm not particularly overworked but findiI have become a terrible procrastinator. I've blamed a bereavement and menopause, but maybe the job's just not for me.
Anyway, I've resigned and planned to retire, but I saw a very PT role advertised on a good day rate doing something similar to what I was doing 20 years ago. I excelled in the interview, if I say so myself. When the interviewer called to tell me I was successful they said they couldn't believe their luck!
And for the first time in ages I find myself excited about getting my teeth into something and doing a good job at it.