My experiences:

with AA, as an elite (gold or above) AND member of AAdmirals Club, then hotel is paid for weather delays. NOT for non-elites that are AAdmirals members, and NOT for Elites that aren't AAdmirals members.

With UA, no hotel or other compensation for overnight due to weather unless you're 1K.