I know this has been posted before, but it's always good to revisit - in case someone hasn't seen it, or has forgotten.
One key takeaway is that foaming polyurethane glue (like Gorilla Glue, or its imitators) is NOT a good choice in general. It does not fill gaps with strength, and even with good joinery, it's not very strong. Not covered in the article, but it also tends to contaminate adjacent surfaces worse than some of the others. I don't keep in in the shop at all.
Another reassuring bit, for me, was hide glue. I don't use it often, and I used to keep a whole 'hot-glue' setup on hand for those few times. Turns out the Liquid Hide Glue (Franklin makes the one I use) is just as good, if not better... and FAR more convenient. I went that route years ago, but it was nice to see my impression confirmed by the article.
Another interesting bit is that - where 'waterproof' isn't necessary, basic PVA is very good (Elmers or Titebond).
https://www.oldbrownglue.com/images/...urGlue_FWW.pdf