How bad is it to trigger the overdraw protection in the PSU? Obviously my PC would shut down immediately (with all that entails), but would I risk damage to components?
I suppose theoretically low voltage could damage something, but I doubt that it's very likely.
I'd probably favor getting the PSU, because otherwise, if you hit any stability issue, you're going to be thinking "is it the PSU"? But I wouldn't be too worried about component damage.
I'm set on the 7900XTX, as I want the 24GB VRAM. It's quite literally the cheapest option (new, in my region) that is also a usable gaming card.
Note that if you're wanting local AI compute capacity
the likely reason to want a lot of VRAM attached to a GPU other than gaming
and you can live with less memory bandwidth and a substantial price bump isn't an issue (which it sounds like it is, but just throwing this out there), you might also consider a unified memory computer, like a Framework Desktop, as that can take a lot more memory than a consumer GPU. I have a 24 GB XT 7900 XTX and a 128 GB Framework Desktop, and I've found myself using the latter rather than the former, especially for LLM stuff.
If you're willing to wait until 2028, my expectation is also that memory prices will be better and thus bang-for-buck on local AI compute will also be better. Also give the hardware guys time to iterate on hardware; probably improve performance.