Something so boring it is the opposite of awe inspiring.
Everyone in the slam dunk contest showed us things we've seen before, it was yawn inspiring.
Someone who looks good from a long distance away, but upon closer inspection, is ugly. Like a sand wedge, good from 75 yards.
I saw a hot girl across the club, but when I walked over it turned out she was a sand wedge.