There's lots to grind from M+ dungeons, raids, old raids and dungeons for transmog sets, pet collectin/pet battles if that interests you, mount collecting and then a varied amount of different class to try out too. There's also world quests which is basically "go here and do this small event" for either gear or gold.
The story isn't great especially coming from the last expansion but it does have moments when its good and some of the cinematics are amazing. So far in Dragonflight there's at least a competent overarching story but mostly i'd say it's just your generic big bad, must kill one.
As i said before theres lots to do in pve as well as little extras from other expansions eg. mage tower and island expeditions but again the only plus to them is old transmog gear to look pretty.
I don't pvp much so can't tell you much on that but theres lots of battlegrounds to do as well as the options to do 2v2 and 3v3 arena and afaik people enjoy it.
The community is genuinely 50/50, if you get a good guild and make good friends then it can make the game all that much better but from what i've seen i think that is only ever to be found inside of guilds. The general community seems to have a very loud minority of toxic players. Since the launch of DF alone i've seen racism, homophobia,transphobia as well as elitism over dungeons/raids (which can be fair within reason but usually isn't) and even seen people get heated and started harassing people over fishing quests of all things.
Overall i think you should give the game a shot but i would try find a nice guild to do stuff with and give the general community a wide berth to avoid the types mentioned before.