I still can't figure out what the appeal of WoW was, but I'm guessing it was the insanely large community?
For many, it's an online third space. Cooperating to overcome shared challenges reinforces social ties. The game provides a weekly schedule of activities and new challenges quarterly.
My credentials: I played every expansion (but not every tier) since vanilla with the same group of people. I only stepped away in The War Within after family obligations and time zones got in the way.
As someone who used to have a WoW problem and now and then relapses, it tickles me the same way Cookie Clicker does. It’s nice to see number go up.
Back when I was playing with my friends and the game was a little harder (BC & WotLK), there was a sense of shared accomplishment when overcoming difficult regions and raids.
There was a time when the community was the attraction, although I wouldn't say "the insanely large community", given that at the (for me anyway) best/peak WoW times, your specific community was the server, which was maybe a couple of thousand or so?
Around that sort of time you would encounter known groups/people, e.g. characters that had a reputation as extremely good in PvP etc.
Then along came the cross-realm stuff, and fairly quickly community ceased to matter, you just queue up, play, and move on.
Great for ease of play etc, terrible for community.
(Well, that was how I saw it anyway).