Regarding screws however, furniture made from wood using approaches traditional for wood-made furniture - don’t rely on screws all that much, but rather mortises, dados, and various other joints held by glue, dowels, and sometimes staples or furniture nails that assist holding joints together until glue dries. Once dried - glue is often stronger than the wood it holds together and attempting to separate the bonded pieces results in splitting the wood rather than breaking the bond.
https://www.furnitureparts.com/products/cam-lock-nuts-ikea-p...
These turn the force into compression over a larger diameter so it's less likely to cause a problem.
I've actually had pretty good experiences with Ikea stuff holding up over time, even across multiple moves.