It's never worth it to buy a console to play one game. Especially when that game is available on other platforms too. If you have the budget and you intend to play other games after, the PS5 is a fantastic machine. Otherwise, just wait for the Switch version of Hogwarts Legacy or get it on PC. If you still want to buy a new console and save money, the Xbox Series S is an option.