"We ideally need a 3/4 bed for approx £800k."
As others have said, you might be surprised how expensive some parts can be (eg Hale Barns, Hale, Bowden etc).
Even Sale can be quite expensive. For example, this is a four bed detached house on Framingham Road which is about a 5 minute walk to the Brooklands metrolink station that goes direct into the centre of Manchester.
https://www.rightmove.co.uk/properties/152513678#/?channel=RES_BUY
or this one a bit further away on Brooklands Road for £750k
https://www.rightmove.co.uk/properties/154208285#/?channel=RES_BUY
Timperley is also really nice but the village centre really just has a couple of Indian takeaways and a pub.
.
"Having a community feel town/high street nearby. ie would like to be near some cafes, bars, restaurants, cinema, exercise classes etc"
This might be a bit of an unusual suggestion, but how about Wilmslow?
That may have more of the vibe that you are looking for?
"Easy ish to commute into Manchester and can get train to London"
It takes about 20 minutes on the train to get from Wilmslow to Manchester Piccadilly (but there are much slower stopping trains). There are also direct trains that go from Wilmslow to London Euston.
As well as older homes you also get a lot more new-ish homes as well, like this 1970s ish detached house for £800k
https://www.rightmove.co.uk/properties/153964088#/?channel=RES_BUY