WWYD with this friendship

[Realistnotpessimist]

I've been friends with someone for about 3 years. She's a nice person but I find the friendship hard work. She over analyses everything. She does online dating and I can't cope with the analysis of each new date. If he does reply to texts within an hour she thinks he's 'ghosting' her, thinks everything is a red flag etc etc. I can't even bare the teenage type language of things like ghosting. We're both in our 40s. She's constantly saying she thinks the world of me and thanks me for my friendship all the time. While this sounds lovely I find it very over the top and quite awkward. I was supposed to go to hers last weekend and for the first time I cancelled as I was quite low and couldn't cope with her analysis of everything. She then sent messages saying she thought she'd upset me. She's a nice person, she really is but I just cant cope with her constant questioning, doubts and over analysis of every situation. I don't know whether I should let the friendship go but I know she'd be really upset. I know she wouldn't cope with an upfront conversation explaining how I'm feeling either.

To make matters worse she had something big happen about 6 years ago and she has only told me which I know was a big thing for her to do. I'm a much more private person.

WWYD?

Has she always been like this?

It sounds exhausting, I don't think I could continue the friendship

She's been like this since I've known her but has perhaps got worse. Not sure what she was like when she was younger. That's exactly the word. It's exhausting.

I've had people like this in my life. I avoid them these days because it's just too wearing. "Why would he say that?" "He said this and he obviously meant that"
I take people very literally and at their face value so all the constant interpretation of bollocks non-signs really does my head in. Maybe other people have more patience with it all.