I don't want a house I have to work on.
A. I'm not a construction worker, barely a handyman, so basic plumbing and electrical, hang doors, replace thresholds, that kind of thing, but I'm not doing roofing and not getting into the foundation and walls like some of you guys. I just want to live in the fucking thing.
B. I've got more enjoyable things to do with my time.
I've done construction and I outsource some things which you mostly listed. Depending upon walls, I'll do it... framing out and hanging sheet rock I'll do. I suck at mud work so I outsource it.
One doesn't have to buy a complete fixer upper to get a good deal. Avoiding fresh 'remodels' helps bring the price down.
I've seen two issues brought up in this thread:
1) Actual price of house. This gets adjusted by lowering your 'must haves'. Too much "I'm only buying my dream house in the middle of this urban area" from people not in this thread. A 2/1 is a suitable starter house but I've seen too many 'too small' comments. Outside of the big city and 'main' suburbs gets the price down... add 10 minutes/miles to your search radius.
2) Down payment. Stop doing all the fancy food, entertainment, electronics, etc... that will get you toward a down quickly. Suck it up and deal with PMI for a year or two while you pay down the principle and/or wait for house to appreciate to get to the 80% threshold. Yes, it is throwing away money but can be gotten rid of relatively easily... an extra $100-$200 a month goes a long way.
For both of my houses, I took a compass and drew a circle on a map showing me roughly 30-40 minute drive(first house) and 60 minute drive(second house) from my work. I then 'drew' another circle saying 'fuck being this close'.
For my first house, I 'worked backwards' from how much I spent on rent to determine what I could comfortably afford. FUCK listening to mortgage brokers that want you to get the biggest loan possible. My mortgage, prop tax, and insurance for the month was basically the same as what I paid in rent. I could have stretched it by 50% more but I said fuck that.
For both of my houses, I did a spread sheet showing 'must haves', 'nice to haves', and 'cool if it has it'. I then rated each item within the group with a 1-10 so I could then refine within a group least important. For example, one second house, I had garage/shop as a must have... but I left it as open ended with the caveat of 'place to put a garage/shop'. I sacrificed having a shop now for a cheaper upfront cost on a good piece of land.