For 1080p 60hz/fps gaming, the RTX 2060 regular model is plenty powerful enough, and less expensive. If you can afford the Super model, then it's not a bad idea especially in light of the fact that game difficulty and hardware requirements seem to go up every cycle, but if NOW is your only concern, then that standard card is more than capable enough of Ultra gaming at 1080p for pretty much everything out there.
There is no "future proof" ANYTHING when it comes to hardware. What works at the highest levels today will only be a middle of the road product in terms of performance down the road a year or two, and the requirements of the software will likely go up along with them. That's the way it's always been, and that's the way it will...