Whether it's right for you OP depends on who you are, and who your DP is, and what your DC are like. So I'd never say 'Yes' or 'No' - as you can see from this thread, some people have lived in building sites for years and loved it, and some people wouldn't consider it because they know they'd hate it.
My experience, for what it's worth, having bought a 2 bed terraced 1890s house with a dodgy loft conversion, which was rented out, so in theory perfectly habitable, is as follows:
- we bought it for over 10% less than it was initially marketed - and that was our banks mortgage valuation figure as well
- we had £15k in cash after purchase - that went in six months on new bathroom, boiler, and two urgent windows
- next spend was a further £5k on windows - the ones that weren't actually letting in water, but were letting in (and out) everything else
- next was £7k on the roof - just the main roof - the kitchen/bathroom extension needs doing next, and the roofers were shit, and it took three months instead of three weeks, and we had a flood due to them taking off the tiles and not covering up just before a (very obvious) night of rain, and they misplaced the guttering so when it rains hard it's like a horse is taking a slash off the roof
- next (coming up next week - hurrah!) is £5k on relevelling the bay, reflooring and insulating the lounge, a new consumer unit and adding a couple of sockets
In between all this spending, we've also done a lot of DIY, including all the painting, sanding and varnishing the floors throughout (got 80% through the lounge and realised the boards were too full of woodworm and holes to make it worth continuing), plastering small bits, digging out and constructing a small channel drain, bagging up 6 bags of soot from the bottom of a very damp chimney, fillering and sanding the render out back (noticeable lack of water indoors afterwards - result!), fitting skirting board and architrave, and (the only one I really enjoyed) peeling layers of crap off a couple of corbals. It's not an impressive list, but my point is that we're not the types who get the decorators in if things aren't perfect.
For the future - we need a new front door, and new windows in the loft. We really should get new loft insulation and plasterboarding and skimming, and sorting out the (damp and asbestos filled) lean to. We want built in bookcases, a built in wardrobe in our bedroom, understairs storage, and a tiny kitchen extension.
We're two and a half years in. It's been tough, and I have regularly wanted to burn the place down and collect on the insurance. We're in our mid forties, and both have very busy jobs. And it quite often feels like we're wasting our lives, on something that is, after all, just a reasonably (we're getting there!) watertight and weather proof box.
Still, we're all different.