I’ve definitely been preferring a transparent background on my terminal lately, particularly when I only have one screen, because it increases my ability to read the reference material I have opened behind it. At the very least, if I have to alt-tab it out of the way, I’m already oriented on the page. So I can see the benefit in at least some use cases.
I don’t think I’d like to have it on everything, though. Or basically anything except my terminal, for that matter.