I have a 3080 with 10 GB VRAM.
I wasn't getting very good results with Automatic1111, it felt like I was spending more time fiddling with config than getting the images I was looking for (nothing special mostly generic home hardware type objects, but done in a specific and consistent style and view).
32 GB VRAM won't be common for at least another 5-7 years IMO, perhaps more.