CENSUS OF SELF-OBSCURED MASSIVE STARS IN NEARBY GALAXIES WITH SPITZER: IMPLICATIONS FOR UNDERSTANDING THE PROGENITORS OF SN 2008S-LIKE TRANSIENTS