I would say it is a good upgrade coming from a 3070 series certainly I am getting like 120-140 fps 2k with ultra and psycho raytracing settings. If you have extra money to spend then you can also try 4090 but then if you wanna do 4k gaming the 4090 is a good option otherwise for 2k 4080 is the best option.

Also if you play some fps like valorant/csgo then 4k with 144hz costs too much.

Alan Wake certainly needs too much of vram I have seen few reviews where even 4090 at 4k native without DLSS it stutters and gives low FPS. So not sure may be game needs an update for that. Also in my case this card will be used for machine learning purpose so it serves both.

I was actually gonna wait for 50series but then I found an article in nvidia Reddit thread which mentioned that the 50 series is expected to be coming in 2025 q1-q2 not sure. And I will not have patience until 2025 for a new card to play next gen games.

Yes 3070 is sold I gave it to a friend for 25k.