Well I have looked at memory usage in depth in a load of modern games specifically because of this thread. And as I've said vRAM budgets for the most recent games like Doom eternal show about 1/4th of the memory being used for texture pools, verified through engine variables. That's why budgets especially for more open world games are more complex today than they've ever been, because the engine doesn't keep a fixed set of textures in memory, they maintain a dynamic pool of memory for textures and stream textures in and out of that pool as you move through the game space.
Yes textures can take up a lot of memory but most surfaces in a game do not benefit from textures that high resolution. A 4096x4096 texture is nearly twice the size of a 4k gaming monitor, the only way you can appreciate the added detail is if it literally fills the entire screen (say a FPS game where you're face to face with a wall using a 4096x4096 brick texture). If you move, and that same wall now represents some patch on your monitor that's say 1/4 of the size (a 1080p patch at 4k) then textures above 2048x2048 wont show a benefit. And that's a worst case scenario it's extremely rare a texture will fill the entire screen.
That's why we mipmap textures to lower resolution variants, to display those low resolution variants on more distant objects or objects at obtuse angles. That's why engines have LOD systems and texture streaming and can throw out the really high resolution textures once objects that use them pass through the various LOD boundaries.
And that's IF you're using 4k which almost no one does. The vast majority of gamers are in 1080p for whom 2048x2048 textures are fine.
It's why if you look at UHD texture pack review here, there's loads of people saying it doesn't make a difference
https://store.steampowered.com/app/...iege__Ultra_HD_Texture_Pack/#app_reviews_hash
But we do, the PC has always had extra high res texture packs the consoles don't have, for the devs that can be bothered to put in the extra effort. FO4, R6, WDL, KCD. They all work inside 10Gb just fine. Again including WDL which is on the next gen consoles but doesn't use the texture pack. The biggest impediment to better games on the PC isn't memory it's developers making 1 size fits all game and not putting additional effort into the PC. Some devs do and the PC variants look way better.