We did this 15 years ago. We really very much wanted to move from our last house as it was too small and we had done all the work we could do to get more space.
Every bloody house we really lived we lost either because of a problem in our chain and we’d been gazumped for than once too. We finally had a house we liked (road was a compromise) and a good buyer (was also getting divorced and HAD to sell their house) who was selling to a developer. Our purchase was meant to be going into rented as they were building a house
Only they decided late into the process not to move into rented right away, wanted 6 months more and wouldn’t exchange with longer completion (we would move into rented) so to keep our buyer, we bought the house we’re in (ie was empty, had been a rental house - no chain) and still here 15 years later
We have done lots of work to the house
With the stamp duty holiday, we thought to take advantage and move. We couldn’t really find anything we liked more than our house.
So yes, you can buy a house you don’t like - and make it something you like.
Our last house was also something we compromised and I didn’t really like - but we needed more space from first house. We lived in that house 10 years. We bought wisely for location and the actual accommodation. Sold it for double the purchase price (we did spend a good amount doing things to it)
So just be sure even though you don’t like the house, that you’re buying wisely so you can move in eventually and make money in the sale. Viewing this purchase as a stepping stone to next house is one that is very helpful