I'm not sure whom I would classify as the "type". I think it just surprises some people because I'm an anomaly in the combat engineer world. While most 12Bs (Combat Engineers) have a certain cunning, and, in my experience, slightly higher intelligence, they are not the most academic in nature. I, on the other hand, have a very academic personality, and only in basic/OSUT, did I ever have what the average 12B would consider a "decent" PT score. My last PT Test, I barely passed.
As for the military spouses, a significant number of their sponsors also have tattoos, as well as the marks of multiple body piercings. The tattoos are not a problem as long as they are within regs, or in some cases a waiver is granted, and the piercing marks are not a problem as long as they are not wearing them while in uniform or while utilizing on post services (PX, gas station, etc.). A large part of it might simply be the corporate world is not ready to lay down its' bias against tattoos and body piercing. It's also been the economy that has driven many service members into the military. Many of these people likely would not have joined if it hadn't been for the lack of entry level jobs that pays a living wage.
Most of the soldiers I know would go nuts in a corporate office. It's not just the corporate cultural taboo against tattoos either. It's the corporate culture as a whole. And while there are those that might find it counter-intuitive that these same people who thrive in the military would hate corporate culture, it's because the military, while having a similar structure to many corporations, is entirely mission driven, and that accomplishing the military mission is a culture unto itself and different than anything the corporate world has to offer.