> I don't think its at all reasonable to suppose that the US simply saying they would oppose Ukraine joining NATO would have in any universe enough to avert war

No, of course not. What NATO should have done was to accept Ukraine as a member. Anybody think Putin would invade a country that can refer to §5?