I am in a same boat as you, and there isn’t really anything on consoles that comes close. I am a patient gamer though, and haven’t played some of the suggestions mentioned here yet.

Witcher 3 is a very good game, I loved playing it and the expansions, had lots of fun, but it isn’t Skyrim. It is still a game you should play though, and depending on what you liked about Skyrim, you may end up liking Witcher 3 much more.

Fallout games come close, character building is different, the world is different, the setting (sci-fi, not fantasy) is different, but it is probably the games that come closest to Skyrim.

People here have mentioned Red Dead Redemption 2 and Cyberpunk 2077, I haven’t played either, but I have played Red Dead Redemption 1, and this is a completely different game. It’s GTA in Wild West, a very good game, but nothing like Skyrim. Cyberpunk 2077 can be a good option, it’s by same devs as Witcher 3, and they know how to make a good RPG and I know people who swear by it. So definitely worth a try.

There are currently a few games in development, that seem to capture the Skyrim feel from the trailers, but we will have to wait for the release and review.

There might be some games on PC, maybe smaller in scope but still capturing the same feeling, but I haven’t explored those yet.