Advancing Automation in Manufacturing: Transformative Technologies and Industry Insights