I think Futurama was a funny deconstruction of that. Fry is usually wrong and not portrayed as cool, but sometimes saves the day. Leela is uptight and bossy sometimes but it's informed by her backstory and if you dig a little deeper, she can be just as petty, selfish, or unprofessional.