Avengers honestly was just poorly executed as it attempted to copy Destiny's playstyle.
As for the next online venture being more Genshin/BotW in nature, I could see that for a new Mana series entry. That kind of open world play style just feels like the next natural step for that particular franchise.
The XI remake wasn't really slated to be an actual remake, More just a remaster to facelift all the visuals since it started as a PS2 game. However there are rumors floating around that they're currently working on an offline version of the title to provide to people when the online servers finally get taken down.
Dragon Quest X also has had rumors floating around about finally being made available outside of Japan. These picked up considerably after a DQ streaming event where they announced an offline version of the game that contained all the content excluding I think the 2 or 3 most recent expansions which was intended to be a way for new players in Japan to essentially catch up without paying the sub since upon completing it, the player had the option to create or link an SE account and port the character into online servers to play the rest of the game. Keep in mind DQX also has an unlimited free trial similar to FFXIV and some in game systems designed to help speed players along the earlier parts of the game as well such as the angel slime hat campaign.
SE also had Front Mission Online back in the PlayOnline days before SE accounts existed which sadly got taken down, though it never left Japan.