It does happen! I mean at that specific point, we were all stressed and uncertain given Hydra had come out, the fall of SHIELD and thinking Director Fury was dead. Coulson thought (rightfully it turns out) that Director Fury had left him coordinates of a secret base only there was nothing but snow and he couldn't find it so felt he'd been led on a goose chase and had led us all with him. Then the badge throwing, motion detector and realising he wasn't wrong.
There has been other times as well just depending on whatever case or crisis we're dealing with for him being frustrated. But it was the above time I really questioned but I was questioning everything at that point as well.
Or the whole debacle with 'Real SHIELD' and well, there have been times his decisions have not worked out and led to more trouble. I understand them but they have led to concerns at times even if things have found a way to work out.