Transforming Electrical Substations: A Deep Dive into Modernization