No guarantee of anything other than a midsize sedan on the emerald/executive aisle.
Largest SUV in DTW exec aisle last week was a ford escape with cloth seats.
Book with Sixt if that’s the price/vehicle you want.
It’s more expensive because it’s the preferred company for business travelers who pay with other peoples money.