Probably some stigma associated with it but Genshin Impact is kind of in the vein of Breath of the Wild with the open world exploration and puzzle solving. Tons of story arcs, and they are pretty dang good. While it’s not offline, it’s not multiplayer unless you want it to be.
I’ll second Elden Ring. Don’t let the idea that it’s a “Souls Game” scare you off. Was my first one playing as well and it’s AMAZING.