Yeah, it's sad, manual transmissions are now offered on some cars as extra cost options. You're right, it's the soccer moms and trend followers that are buying up vehicles like trucks and SUVs for the image and style, but refuse to shift it themselves.
I wouldn't think of buying a sporty vehicle with anything other than a manual trans. Some of the younger guys and gals at work are exactly the opposite and wouldn't even consider buying a manual, no matter what kind of vehicle they buy. One has an automatic equipped Z28 and another is buying an automatic G35 Coupe. These guys got no excuse as my wife, all 4'-10" of her, would always rather drive a manual transmission, she bought a Honda Element with a stick even though she has to make the commute through rush-hour traffic.
As for the automatic being stronger, that's probably just a marketing thing, as all the major auto companies have at least one heavy-duty manual transmission. The reason you can't get an automatic in a Corvette Z06 or Mustang Cobra is that there isn't an automatic strong enough to take the torque of those cars' engines. So the automatic is never going to be the strongest trans available.