The thing I most enjoyed about the stargate franchise was how the alien tech tree was discovered over time. The series didn’t plan for this (I don’t believe) and in later seasons it all got kinda bizarre and wonky. I don’t know of many other works of fiction that took this approach. I think Perry Rhodan series did (I only read a few installments) and the novel Battlefield Earth had this as an element.