It definitely hits different people differently. My wife doesn't get high. I've seen her smoke good weed and she didn't change in demeanor at all and claimed it didn't do anything.
Personally all it makes me do is think about how shitty my life is for hours (hint: my life is fine..it's just the weed) although some indica stuff will make me giggle for an hour before I pass out. I'm worse than useless when high.
There's a huge range in response.
Medical issues are a big exception yeah. I wasn't able to focus at all while high, at least not for a prolonged period of time... I guess it's just different for me. Mostly I stayed up way too late doing nonsense and got very little sleep as a result which impacted my day-to-day activities. It wasn't a good time.
I can't do the stuff you're talking about when I'm not high (or couldn't) because I couldn't stop anxiety and other issues from getting in the way. Weed liberates me from that.
I have friends that hate weed, friends that become different people while high. It's just how it is, not for everyone, though I do prefer delta-8 way more than regular cannabis, not as intense of a high, much more about the focus.