I am in consulting currently and either want to join industry or remain in consulting...in europe or middle east..

Looking into the 2 year visa UK is giving...what do you guys think...as HEC has an exceptional brand name but french is a challenge.

These are odd choices. Manchester has the advantage of being in the UK, where you speak the language, and having a campus in the UAE. 
But you need to focus your goals and see which schools have the best MBA networks in your targeted industries in your favoured countries. Obviously, you will not get a consulting job in the French-speaking regions. 

These are odd choices. Manchester has the advantage of being in the UK, where you speak the language, and having a campus in the UAE. 
But you need to focus your goals and see which schools have the best MBA networks in your targeted industries in your favoured countries. Obviously, you will not get a consulting job in the French-speaking regions. 

I guess this depends on the sort of consulting you mean. The Manchester MBA doesn't have great relationships with the strategy consultancies, and its MBA is best for career changers. HEC does have those relationships but it is oh-so-French. If you don't speak and write business French before starting at HEC, then what consulting firm would hire you? If they want to hire people for your home country, then why not hire them there? 
LinkedIn will show you that Manchester does have a better network in the UAE than most of the too European schools, and full time students can take electives there. At the end of the day, as in the UK, it will be your ability to network that will produce the opportunities. Certainly I do know AMBA MBAs who are working in the UAE. 

But my main point is not that AMBS is better than HEC (although it is for your goals) but that you need to narrow these two regions and two industries down to one hypothesis, and then pick the schools that are best for your goal. 

[Edited by Duncan on May 14, 2020]

Like, for consulting aim for LBS, Insead or IESE: 

But my main point is not that AMBS is better than HEC (although it is) but that you need to narrow these two regions and two industries down to one strategy, and then pick the schools that are best for your goal. 

I means that it is for his goals, since he would not arrive at HEC being able to work in French. A penknife is better than a cup, but not if you want to drink. The rankings have to try to equate schools, but really the top schools are each shaped differently to deliver managers to their major employers, who need MBAs in specific industries, functions and places. 
PS That's one more reason why its so important to have goals. You need to shortlist the best schools, and the top schools pick candidates who meet their major employers' needs. That's why someone with a 790 GMAT, but no goals, can't get into most top schools.

[Edited by Duncan on May 14, 2020]