What home issues would warrent not purchasing a home if found during inspection?

We will be new homebuyers with small kids and love older homes but also want a home that doesn't come with fixit projects that will take days of loud noises and frustration.

What kinds of things should be a hard pass and not worth hiring to fix, or would take a long time to fix?

Im reading articles about it, but curious on anyones experiences?