INSIGHT: A Survey of In-Network Systems for Intelligent, High-Efficiency AI and Topology Optimization