Sounds to me like you have fond memories of the game but simply DON’T enjoy it anymore, contrary to what you say about still “liking the gameplay”.
At the end of the day, we’re still doing the same exact power grind we were doing in WotLK, just with more busywork steps involved now, more trivial early-game and leveling content, and a much more jaded playerbase.
If you burnt out on that (or just didn’t enjoy it anymore upon returning), there’s not much you can do to magically turn the love back on.
WoW has always had a turning point. Once you see the mechanics behind the coat of paint it loses some of the magic. Some people leave. Others still have fun with it. It kinda seems like you might be better off just leaving if it’s not clicking anymore.
If story is your thing, well, we’re in a new era. WotLK effectively acted as a pseudo-conclusion to Warcraft III. Cata, and WoD were blatantly rooted in RTS characters and locations. Even MoP, while a bit of a departure from the norm, was taking directly from the RTS.
That’s not what WoW is anymore. We’ve exhausted literally all of the notable plot points, characters, and locations left in the RTS. BfA basically speedran some of the last ones left in minor patches, for some reason. Some long-term characters carry forward, but there’s no leftover bit to go base entire expansions off of anymore. Everything is new, or working off seeds planted in like Legion or later.
I suspect you’re gonna struggle to attach yourself to the story now that it’s moved beyond what it was anchored in when you played.
I can recommend low level PvE Twinking (Like, 10 - 13 depending on spec) as a temporary thing to focus on just because for most people it’s a new experience and completely absurd to the point that it turns what I view as a negative in normal play into a positive just because of how extreme it is.
Add me on Discord (username: ventorath) if you wanna ask a bit about that.
But that’s not normal gameplay, it’s not going to be the thing that keeps you playing WoW long term, it’s the kind of thing you go do when you’ve been playing WoW for awhile and burnt out and just need a temporary break from “normal”.