Here are some games I have not seen mentioned yet:
Valdis Story: Abyssal City
A 2D metroidvania, with the best combat in the genre. It has infinite combos, parrys, skill cancels, a magic system, and 4 characters that play fundamentally different. You get scores for the bosses, which really motivates me to learn the combat well beyond just finding one thing that works well. If you have any interest in sidescrollers, then this game is for you. Controller is required thou.
Zero Sievert
Ever wish that tarkov had a singleplayer mode? Well look no further, Zero Sievert is a top down extraction shooter, that is still in early access. But whats already on offer is really solid and a lot of fun. It has that tense atmosphere when you find something good and want to extract, without wasting massive amounts of your time.
Ollie Ollie World
A 2d skateboarding game with a unique control scheme, that has a very high skill ceiling. Its score chase, with online leaderboards, daily challanges, seasons, and so on. I like its music and artstyle a lot, but if thats not for you, you can check out the older entries in the series, that look not as 'out there'.
I don't know what you expect from hogwarts legacy, but heres my 2 cents.
If you come for a Hogwarts lifesim, a sort of Bully but set in Hogwarts, with the feeling of attending the school and classes, and take part in school life and interacting with other students, dont buy a console for Hogwarts Legacy.
All these parts are severely underdeveloped and dissapointing. While there are many students standing about all the time, you will only interacty with anyone when a quest requires you to. 90% of npcs you will meet twice: when they give you a quest, and a secend time when you return to them to finish the quest.
If you come to Hogwarts Legacy for a decent action game (i wouldnt call it a rpg, there are numbers involved, but they are absolutly meaningless) with huge collections to aquire, and the pretty, Harry Potter flavoured, visuals, then you will have fun with the game. But maybe don't buy a console just for Hogwarts.