Antiferromagnetic (AFM) spintronics has emerged as a cornerstone for next-generation information technology, due to its inherent immunity to magnetic perturbations, absence of stray field and ultrafast spin dynamics. However, achieving the precise, atomic-scale control over AFM order and its associated transport properties remains a significant challenge. Herein, we report the successful synthesis of [(Nd0.99Ce0.01NiO3)2/(Sm0.95Ce0.05NiO3)n]10 (NCNO/SCNO) hetero-superlattices, where oxygen octahedral rotations (OOR) are systematically tailored through interface engineering. Transport measurements demonstrate a remarkable enhancement of the metal-metal transition temperature (TMM) from 203 K to near-room-temperature 293 K by varying the SCNO layer thickness (n). Crucially, via the zero-field planar Hall effect, we confirm a highly stable AFM order and realize robust detection and programming of spin states. The Néel temperature increases systematically with the enhancement of OOR and exhibits a distinct decoupling from TMM. X-ray absorption spectroscopy reveals spectral changes that are consistent with enhanced breathing distortions and may involve an evolution of the charge-transfer-related electronic structure. Our findings highlight the profound impact of the structural distortions on the electronic states of AFM nickelates, offering a viable strategy for designing high-performance and room-temperature AFM phase-change spintronic devices.