I played just before the dragonflight update. Really enjoyed leveling a few characters, and just exploring the world. Think as others said, it does get a bit stale after some time if you're not running with friends. Also found as a very casual player, dungeons were quite intimidating when you're not with patient players, which could be alleviated if playing with friends.
I'm not looking to get into it seriously any time soon, but would have been fun!