The dynamic behavior of a physical system often originates from its spectral properties. In open systems, where the effective non-Hermitian description enables a wealth of spectral structures in the complex plane, the concomitant dynamics are significantly enriched, whereas the identification and comprehension of the underlying connections are challenging. Here we experimentally demonstrate the correspondence between the transient self-acceleration of local excitations and the non-Hermitian spectral topology using lossy photonic quantum walks. Focusing first on one-dimensional quantum walks, we show that the measured short-time acceleration of the wave function is proportional to the area enclosed by the eigenspectrum. We then reveal a similar correspondence in two-dimension quantum walks, where the self-acceleration is proportional to the volume enclosed by the eigenspectrum in the complex parameter space. In both dimensions, the transient self-acceleration crosses over to a long-time behavior dominated by a constant flow at the drift velocity. Our results unveil the universal correspondence between spectral topology and transient dynamics, and offer a sensitive probe for phenomena in non-Hermitian systems that originate from spectral geometry.