Emersons is not a sh*thole, it’s not lovely but theres plenty of money there and the local school is among the best in Bristol (I don’t live on the estate BTW).
I’m yet to find any local riding and Long Ashton is close to Ashton court (but that’s crap, I never ride there).
Mangotsfield is also close to motorways(M4 and M5) and the ring road.
There is a dedicated cycle lane which runs through mangotsfield and goes about as far as Filton Abbey Wood (MOD), so it’s quite a safe commute (I do it often). I’d probably avoid bradley stoke AKA Sadly broke.
I think Mangotsfield is quite a pleasant place, no gangs of kids, graffiti etc. Plenty of greenery nearby. If you have a choice, try to move into the village rather than EG, there’s plenty of character.
Oh, takes me 40 odd mins to reach cwmcarn and 1hr15 to reach Afan. I go to one of these every weekend.