I found a server called Avarion and it is an RPG SMP that is built around a story driven world. It is made for mature content creators who want to stick around and make videos or stream.
The server has daily weekly and monthly quests and you can get rewards for doing them. There are RPG classes and custom weapons too.
There is a main storyline but it is not scripted so players can shape what happens. It also has balanced PvP and PvE so fighting feels fair.
There is a custom world with rifts to explore and they also talk about future races and expansions. The vibe is world building with light roleplay and collaborative storytelling.
