I have been doing lots of searches and I seem to get more and more confused as i read on..

I am an Indian, Male with 8 years of experience primarily across Strategy and Supply Chain functions in leadership roles. I work in a automotive/manufacturing US MNC but the work experience has mainly been in India with couple of months stint abroad at UK, US.
I gave my GMAT about couple of years ago with a score of 670 and TOEFL of 110. I have been wanting to apply to schools across and somehow it didn't work out and work continued to keep me busy.
Over the last few months - work has stagnated and really want an upgrade . And about the same time my spouse is getting a transfer to London under T2 visa( shift in couple of months)

I don't want to waste two years in an US B- school (time, energy and the money).
Wish to apply to B schools across UK and mainland Europe -> 1 year course

Below are few of the schools i am targeting

a. Judge/Said --- > with my GMAT score and experience, do i stand a chance?
b. Warwick/Imperial/Cranfield --> Is it worth the money and importantly the job?

For the above , Visa for Non-EU( as i hear) continues to be a challenge.
One advantage, i might have is the dependence visa to work in UK

c. HEC Paris --> Low GMAT score? Not sure of an admit
d. Mannheim ---> Worried with the jobs? and the language
e. Erasmus, Rotterdam --> Job scene? But relevant work ex esp.. in supply chain
f. SDA Bocconi -> Job scene and language
e. St Gallen


I would love to hear your thoughts on
1. The work visa situation in UK
2. B school which would suit my needs with my given GMAT score and profile

Cheers

Given that you are from a competitive applicant group, your GMAT score is on the low side for Oxbridge. Your higher-than-average work experience, and the fact that the work experience is a bit different from others in your applicant group, might make up for this to some degree, but for your best chances you probably want to score in the 700 range. Warwick, Cranfield and Imperial are a bit safer.

In terms of staying in the country after graduation, I believe that as a spouse, you also get work privileges under your partner's T2 visa. This makes you a safer bet for British companies looking to hire and who might otherwise be worried about residency issues. If indeed that is the case, that's good news for you.

In terms of the mainland schools you mentioned, all have their positives and negatives. It's potentially easier to get work visas in some of the mainland European countries, but to get the majority of post-MBA jobs in those countries, you'll probably have to have a solid command of the local language.