Thanks, I honestly was not aware that "adjust window to content" is (or used to be) the intended behaviour. I saw apps that did it over the years, but I remember it being inconsistent even from one Apple app to the next.
I also want to say that I remember Apple changing the green button to a maximise-like function, though I can't remember during which release that happened. Probably when they introduced virtual desktops and full screen apps.
Of course, UX guidelines can only do so much without developers following them. That explains why the green button is so unpredictable. You never know if it'll do full screen, resize the window, maximise, or just ignore you.