I game and have both types of console.
Do you want single player or co operative and do you want building and nice friendly games or do you want to shoot things in the face? I do both. Do you want to build a character, min max their stats? Gaming can be as easy or as complex as you like.
I would recommend you look at you tube or twitch for actual footage of game play.
My most played games are Minecraft, building and exploring, Destiny, The Division, both have some co operative and some player versus player. Call of Duty, Fortnite, PubG, all player versus player apart from the Zombie mode in COD, The Diablo series, Horror games like Zombie Army Trilogy and Dead by Daylight, Overcooked 2, Tetris. Then small indie games. I’m not in to role playing games.
Consider if you want to communicate with others if you go online, it’s a place where misogyny is rife. I do but I have a solid group that I have gamed with for years and used to help people in a game and they were very grateful.
Destiny is my most played game but I would not recommend it for a new player it has been out a decade and whilst some are still helpful it’s not like it was. You could never catch up now and they removed some of the best content. It has a very hardcore central player base, I used to be in it and took part in Day 1 raids.