I have not practiced cowboy coding. It does seem to have some similarities to several manifestations of Agile, such as Scrum, in which teams are self-organizing and have a lot of autonomy. I think Scrum teams are quite enjoyable to work on.
However, the "cowboy" part of it sounds undisciplined and prone to wasting resources. As your definition states, it does seem like a derogatory term.