Welcome back!
If you haven’t already, check out the WrA Directory Thread. You’ll find some info about the server in there, as well as a small list of usually-active RP hubs (it looks like Silvermoon City isn’t listed at the moment, for some reason, but there are usually RPers in a few spots there during peak hours). There are also some guild listings in that thread, though there are many more guilds not listed there that recruit in-game.
In my experience, most plot-driven RP on WrA is done within an RP guild (or non-guild RP group), and not designed to include the broader community. But there are some exceptions, such as the currently ongoing Year of the Scourge campaign that Mordekeiser mentioned; there are a few threads about that on this forum at the moment.