Recursive Hierarchical Data Flattening and Path Tracking

Create a recursive Common Table Expression (CTE) that can completely flatten a hierarchical organizational structure while preserving full lineage and depth information. The solution should handle unlimited hierarchy levels, calculate organizational path, depth, and provide metadata about each node's relationships. Include performance considerations for organizations with thousands of employees and complex reporting structures.