Not at all. A show doesn't get boring just because people are NOT unprofessional, incompetent dicks.
Straw man argument. The characters never behaved like "incompetent dicks", they behaved like human beings do. The square-jawed heroes of SG-1 are cartoon characters by contrast, they do not belong in any sort of serious character drama because they do not represent what it is to be human. There are no archetypical villains in the show for them to bounce off and no internal conflict or intriguing adult relationships likely to develop between them, so what would they actually do? Fly around gathering food and supplies? Riveting stuff.
In fact, having well adjusted protagonists who generally get along makes it easier for you to like and therefore care about them, which enhances the drama.
Like The Walking Dead
? Like The Wire
? Well adjusted "likeable" protagonists are for pop-corn episodics, the comfort food of weekly TV, not for serious sci-fi character dramas seeking to explore the human condition.