I just replaced that exact card in my machine last week in preparation for dual booting Linux for the first time (I needed a new NVME as a Linux drive and figured I'd future-proof my setup at the same time with an RX 9070 XT for the native AMD drivers), and the only games that I hadn't been able to run on medium-high settings had been unoptimized games, bad ports, and early access stuff like Monster Hunter: Wilds and Cities Skylines 2.

IMO 8 gigs is plenty for the average person, all things considered.