In particular I'd really like online games that behave more like Warhammer or D&D, where a large portion of the fun is actually offline, designing your character/army etc.

Bringing it back to your comment, I can across [1], which brings some popular boardgames online. Premium games follow your license model (non-paying players can play with paid members)

[1] https://en.boardgamearena.com/