You're an absolutely textbook example of someone with ADHD. I wouldn't rule out autism - they often co-occur - but your vivid episodic memory is more normally found in people with ADHD (it's often impaired in people with autism). If you haven't already sought a diagnosis, I would urgently do so.

Most of the things you describe are commonly found in both ADHD and autism. ADHD might explain all of it, or you might just have some autistic traits. One thing to consider is how unsettled you feel if plans change on the day: if you feel very anxious, it might be autism, too.

Some of the aspects you describe are related to compound trauma from social exclusion in childhood which is common to both autism and ADHD - that hypervigilance which leads to that exceptional ability to read the room, which is very useful, but you may need a little therapy to help you learn how to self-regulate. (This is normally CBT.)

People with ADHD commonly become teachers (or consumer researchers, or journalists). That ability to see those hidden links, to get to the answers behind the answers, to read the room) will serve you well.

People with ADHD are commonly 'late bloomers' in their career, and combine the skills learned from a variety of roles into a strong generalist skillset like product management or strategic consultancy.

A startup founder surveyed his associates in a founders club and asked them questions including about ADHD traits. He found nearly two-thirds of this group of successful CEOs (each with millions in revenue) had ADHD traits, and that those founders' companies were the fastest-growing and most innovative. Those traits now their competitive advantage.

The average age of a successful company founder is 45. You are much younger than that.