In general it's not a problem to find a manual car here in Canada. 8 years ago When I came over from Europe I got a used Hyundai Elantra. Kijiji lists ~95k automatic and ~15k manual cars for sale. But - my wife can't drive it, many other people can't drive manual. So you'll always be the designated driver :-). Pricewise it's not cheaper, maybe even more expensive than an automatic. Today's automatic seem also to be more fuel efficient than a manual car. That was not the case in the past, but due to the recent development in electronics it's more difficult to beat the automatic. Have fun driving around here. The signs are all different, the signal (if they signal at all) is a red light not a yellow one. There is no mandatory safety check on cars on a regular basis, so even the oldest, unsafest cars can still be driven. And speeding can be very expensive :-).
To find out about the local market go to autotrader.ca or to Kijiji