I dipped out during the tail end of WoD too and didn’t come back until around the end of Legion. I wasn’t as big into the whole RP “community” back then, but in the past couple of years, I’d say things look like they’re going pretty well. The Valley Honor remains the go-to spot for walk up RP, and Silvermoon remains a preferred hangout for Elves, although you’ll have be more pro-active there to get things going.
And of course there’s a bunch of guild and community stuff going down on the various Discord channels. WoW’s in game community chat system never really took off.
And there’s the Horde guild roster so you can see what new guilds are in the mix and which ones have retired.