Op - I am absolutely not qualified to diagnose you with anything but I have worked in the mental health field for almost 20 years.
it definitely seems like there is something about how your brain is working that is interfering with your everyday life.
It could be burnout / overwhelm, autism, ADHD, menopause, trauma - all sorts of things.
One thing is clear - it’s NOT because you are hopeless or lazy or stupid.
I would 100% recommend you talk to your GP about your executive function skills (Google will give you a list of what they are) as well as your brain freeze and other issues.
the fact that ADHD seems to be ‘all over the place’ at the moment is because there have been breakthroughs in research that show how it manifests itself in adult women and so many of us have gone ‘omg, that explains EVERYTHING about me!’.
It’s also a bit of ‘life algorithm’ - as soon as you start thinking about something, you start seeing it everywhere.
A diagnosis of something might really help you to learn how your brilliant brain works and how best to organise your life to play to your strengths (of which you definitely have lots!).
A drop in oestrogen can also make it harder to mask ADHD behaviour so that might be why it’s suddenly more noticeable (depending on how old you are).
Good luck - you are NOT losing your mind, you are brilliant - you just need to work out how your brain works and how to best work with it and not against it.