Where did the stargate franchise go wrong? It seems to have grown huge, then went up in a puff of smoke almost as quickly. Was it overextended, or ran out of ne

Where did the stargate franchise go wrong? It seems to have grown huge, then went up in a puff of smoke almost as quickly. Was it overextended, or ran out of new ideas to work with?