Yes, it is very safe to say the GeForce 8800 GT was the superior choice for Mac OS X 10.5 Leopard.
While the HD 5000 series is the king of Snow Leopard, the 8800 GT was the absolute performance leader for the Leopard era, especially for gaming and 3D work.
Why the 8800 GT ruled Leopard (10.5)
Raw Gaming Power: In 2008, the 8800 GT was significantly faster in OpenGL benchmarks (like Doom 3, Quake 4, and Halo) than the stock ATI Radeon HD 2600 XT or even the high-end Radeon X1900 XT.
The "G92" Architecture: This was NVIDIA’s first massive leap into modern unified shaders. It handled Leopard’s UI effects and 3D applications much more smoothly than the older ATI architectures.
Native Stability: Because Apple sold this card as a high-end "Upgrade Kit" for both the 1st Gen (2006/2007) and 2nd Gen (2008) Mac Pros, the drivers were deeply integrated into Leopard. It was the most stable "power user" card of that specific OS version.
The One Exception: "Pro Apps"
There was a small "catch" at the time:
Core Image: Apple’s "Pro Apps" (like Aperture, Motion, and Final Cut Pro) relied heavily on an engine called Core Image.
ATI cards (like the later Radeon HD 3870) were actually better optimized for Core Image than NVIDIA cards. If you were doing heavy video editing or photo work in 10.5, the ATI 3870 could sometimes outperform the 8800 GT in those specific tasks, even though the 8800 GT was faster for everything else.
Summary for your Builds
For 10.5 Leopard: The GeForce 8800 GT is the undisputed champion for speed and compatibility.
For 10.6.8 Snow Leopard: The ATI HD 5770 / 5870 takes the crown because it supports newer technologies like OpenCL that 10.6 introduced.
Since you've been working with the ASUS P5B Deluxe, the 8800 GT is a perfect period-accurate match. It feels "right" for that hardware and will give you the most authentic 2008-era Hackintosh experience.