Finding those places is very hard. As soon as an agent gets a whiff of one of them (and looking for them is literally their full time job), either they or someone they are close with will do a quick tart and flip hiding all the potential issues. Honestly, I would pay less for a flipped house than a dated one as at least I can see what I'm dealing with. It's sad that there are no repercussions for flippers destroying the housing stock (eg. bury water issues that then have another decade to develop and you need to remediate the whole house instead of a bad shingle and a dehumidifier).If I was looking to buy I'd go for the untouched original place and use the savings to do the kind of renovations that are important to me.
To get those places you have to think like a real estate agent. Look for tired places with old owners. It sounds ghoulish but follow the obituary columns. Mom or pop dies and the survivor might be thinking of moving to a home. No one is going to put a house on a platter for you.