Everyone in life that has stepped and loved as sat on both sides of this coin.
I know I have done it, and I have also had it done to me by several partners (including one woman who pulled up a chair and watched me sleep [picture that wake up call].
It is part of being vulnerable in life, one will step up and do the "oh no TV actor, don't do that ... noooooo"
The dirty little secret is needy as long as boundaries and communication is kept up gives you a signal that if the person is well formed (big if I know), you have a good chance of not having dead bed marriage or a partnership where you sit across from the other and say where did the spark go.
Now one shouldn't be the male or female James Cann in that movie where his #1 fan kept him locked away, but one should have sparks of tht desire in the best possible way.
The triggers you stated at the end are a red flag, and a reminder to tell you as you meet partners that see this brilliant, strong woman with so much to give, that clear and concise communication is queen/king.
You are absolutely correct. I hope you meet the partner that makes you feel really needy and wanty (in a enthusastic consent way).
Good luck and I feel you. As a high performing person, the thing I need some nights is coffee and a book and quiet. I need inner peace even as an ENFP.