feat(tests): overhaul staging test infrastructure and update fixtures #1439

Job	Run time
Collect changes / collect-changes	11s
Python tests / docs-scripts-tests	23s
Python tests / types-check	24s
Python tests / unit-tests (py310)	3m 16s
Python tests / unit-tests (py312)	2m 33s
Python tests / unit-tests (py314)	2m 37s
Python tests / lint-and-format-check	19s
Python tests / unit-tests (py311)	3m 12s
Python tests / unit-tests (py313)	2m 36s
status-check	2s
	15m 33s

Provide feedback