I've lived in Emneth for a few years and it's OK. Not brilliant, not awful. Better than Wisbech.
There are a couple of small shops, post office, cake shop, a really good (but small) swimming pool, spa and apparently a chippy coming soon.
The village has its issues, and as anywhere else, it depends which of the roads you move into as to the reputation/expectations you should have. Emneth is basically five roads leading to the village square. In order of nice to not nice it goes Church Road, Hollycroft, Hungate, Wroe, Lady's Drove.
If any of your kids have SEN you'll need to go over the border into Cambs for GPs and schooling. Being able to drive is essential.
Things I like = space, night sky, proximity to places I need to be, have made some lovely local friends
Things I don't like = very 'small minded' views from quite a few other locals, people have low expectations, this area isn't the 'romantic' rural living idyll - it is the scruffy rural living reality
Spend time up here before making the leap, it's the only way to know.