Lots of differences in the engines...small, but differences nonetheless.
The 1993-1994 engines had a two-piece intake manifold and generated 270 hp and 295 hp for the LD8 and L37 versions respectively. I believe the 93-95 engines are also speed density controlled, but I could be wrong on that.
In 1996, they switched to a composite intake manifold that increased the horsepower to the common 275/300 that we reference today. The '96+ engines have MAF sensors. Sometime in the 1996 timeframe, they upgraded the seal at the case-half joint making that leak much more uncommon. In addition, sometime near the 1996 timeframe, they upgraded the valve springs on the LD8 engine. Historically, the L37 had stiffer valve springs, but sometime during 1996, Cadillac started using the L37 valve springs on both engines.
If I had my druthers, I believe I'd take a 2000+ design. It's optimized for regular fuel, and they lose the spark plug wires in favor of a coil-on-plug ignition system. But I can't say anything bad about my 1997 example. I haven't had a single engine problem with it...haven't even had to remove a cam cover. The only things that've been replaced are a A/C compressor bearing, an alternator, and water pump (and the plug wires after the fuel rail recall).
If you want to talk strict numbers, I believe 1995 is theoretically the "best" one...it has the upgraded composite intake manifold and doesn't have a MAF sensor that I recall...so in theory, it might make 1-2 hp over a 1996 or later engine due to SLIGHTLY less restriction in the intake from the MAF sensor. But in essence, all FWD Northstar engines use the same block and internals, performance-wise.