https://store.steampowered.com/app/2382520/Erenshor/ is a single player mmo with simulated other players.
You may also want to check Valheim and the like out.
Also, F2P games are definitely a thing. Warframe and Where Winds Meet are both not really cash grabby to play.