FWIW: Any car made in the last 20 years is almost entirely metric.
Most mechanics should have dual SAE/Metric sets, the only exceptions I've found are dealer guys 100% dedicated to a single brand that's always been metric. I have less specialty stuff in SAE, but cars/equipment that uses SAE is typically old enough to be wide open. Most aftermarket parts use metric sizes I find, except the jeep/truck community, which specs 100% SAE hardware because 'merica. Almost always coarse pitch too.
Replacement hardware is either purchased by the shop, or from my personal stockpile. I normally specify metric hardware even for things like exhaust. Far too easy for 3/8 hardware to become 5/8 or whatever. M8 by 1.25, there is no question. Of course, you normally need to specify the length in inches. Bulk stuff the shop occasionally manages to stock is all SAE, because it's cheaper.
Thread repair I'm 100% metric regardless of application. On most equipment there's room to step up a size as well, so I go from SAE coarse to metric fine. Much easier for me as I'm personally supplying the hardware more often than not. Any time we do an engine or scrap a car, I harvest every single fastener I can get my hands on, down to the rod cap bolts. I have piles of m6x1 (10mm heads typically) and m8x1.25 (12-14 head). I also find metric much easier from a tapping perspective. Subtract pitch from diameter and you have a good approximation of drill size. 8-1.25= 6.75 drill (for m8x1.25). 1/4 is like 6.3mm, so grab your HF micrometer and a 64s drill bit index and start above 1/4.
You are right, some metric can be tough/expensive to source local. M10x1.25 can be a real pain, as can any m12. Head size is another issue, as car fasteners often have flanged heads and smaller head sizes than what the hardware store stocks. For basic projects I typically buy 100% metric if fastener choice is not dictated by another requirement. Metric thread means metric head sizes, and my eyes are trained to "see" in metric. I look at a bolt I identify first by pitch, then diameter, metric style.
Until I came to GJ, I didn't understand the love and obsession some have with SAE; as though still using SAE is some sort of badge of honor. I find metric to be objectively superior, and it is also what most of my work entails. I find small measurements requiring fractions of an inch are inferior to using centimeters, for my eyes anyways. I see lots of guys on here buying/selling SAE stuff, I can't really wrap my head around what one would actually use it for, but different strokes I suppose.
Edit:
Examples of NEEDING SAE: Plumbing, brass fittings, air lines, hydraulic stuff, basically anything relating to a tube/pipe. Some brake line fittings used 3/8 heads into the 2000's. I know some equipment uses it, buffers, riding mowers, plus classic american stuff.