If something is "stupid awesome," it is so unreasonably awesome that only someone who is unable to reason at all, a stupid person for example, can fully appreciate how awesome that thing is without their head exploding.