I found love again in my Marksman Hunter and can play it very similarly to how I played it in Legion so it revitilized the fun in gameplay, but the big NO is still here, not really much to progress outside gearing and the solo content is subpar. Though that new solo dungeon is nice.
I find fun in PvP(BGs) and some PvE which is what I do now mostly. But WoW will never be prioritized anymore like it did, its just more fun games out there.
To enjoy WoW? Find a class which is really fun and you'll forgive the expansions shortcomings(mostly)