Having lived in both places, your social life would be far far far superior in Dubai.
The quality of people in Doha is worlds apart from Dubai.
Places to dine out, driving around, socializing, and pretty much life outside of work (since we are discussing pros and cons of living in the two countries only), would be far more dull in Qatar.
On the upside, you would save alot more money because there genuinely are not much places to go. Most places to dine or drink out are vastly overpriced, and tons of people decide to hang around and stay in (another reason why it makes it tough to meet people).
Most the women you would be able to meet would be crew anyway.
It's not a bad life in Qatar, it just depends if you are able to make a few close friends and live in that bubble for your time off.
Its not easy to meet people, certainly not as easy as it is in Dubai. There less to do. You have tons of people just hanging around in the beaches in Dubai, strolling around, etc.
In Qatar its not got a fraction of that vibe.
If you have a family Qatar could be a much easier place to live. As a single guy with most your social circle likely being pilots anyway, it could get lonely for you.