Other than a Jeep Wrangler I don't know of any SUV that comes with a manual transmission. Most of these vehicles are sold to soccer moms and they don't want to shift gears.
I know there are zero US makers who sell SUVs with a manual (except the aforementioned Jeep). You might be able to get an Nissan Xterra or a Subaru with a manual. I doubt iof any BMW or Audi or MB would come with a manual. At least none that are sold in the USA.