A fellow westchester ex UK person here, welcome to the county! (or nearly anyway) If you need anything, feel free to message me
Mazda (the 5 or 9) are (imo) one of the best AWDs around in relation to price, as they come fully loaded with most features if you go for the mid range model. When we got ours last year, the only thing we didn't get was the feature that stops the car automatically if you're going to hit someone.
Westchester has a TON of dealerships for Honda, Mazda, Mercs, subarus, Lexus etc so you can't really go wrong for either new (which are mainly all leased) or pre owned (and certified, and generally ex lease) and you get a better deal if you can put more $$ down upfront.
Seconding the comments on automatics above, i wouldn't go back to manual now if you paid me!
A couple of things to note if useful, is that mpg is woeful in most cars here - my Mazda CX5 does on average 17 mpg (and thats mainly school runs / local daily with a couple of big trips a week) whereas in the UK it would regularly hit 30+
The other one is driving licenses - you'll need to swap your UK ones out pretty quickly (I think its 30 days of being considered a NY state resident) I highly recommend doing the paperwork and test out of NYC if possible, as its chaos in most of them. White Plains has a branch of the DMV and I'd recommend there instead of the one in the Bronx or Yonkers.