Rent a Wreck might have standards:
http://www.calgarycarrental.ca/
As getbak said; anything you get in standard will either be very low end, or a sports car. Is he aware that most cars sold in North America are Automatic? He may think he has a choice- in Europe the rental cars are available with both transmissions.