Well, if you have a 93 L05 or a 94 and 95 LT1's you are stuck with the old PG250 starter. The PG250 is a good reliable starter (mine just came off at 235K miles), but they are very difficult to rebuild and parts are not readily available. Don't get into one of these if you aren't very mechanically inclined. And when you read the warning about the strong magnets able to pinch you. LISTEN! It will BITE you!! It got me and I was trying hard not to. If you aren't very careful it will draw blood.
A lower cost (rebuilt to rebuilt from most auto parts stores, here it is $160 for the PG250 and $130 for the PG260M) is to upgrade to the 96-97 LT1 PG260 starter. The PG260 is a even further gear reduction with more power and lighter weight. Less current draw than the SD250/5MT starters. 10MT's will NOT fit an LT1 no matter what you do.... I am not sure if the SD250/5MT will fit. The only "mod" needed is to install shorter bolts. Around 1/2" is needed less, more like 9/16" less is ideal. I just used 2 old lug nuts as spacers with no issues at all. You will LOVE the lightweight of the PG260M. It is almost wrong how right it is....
A little background:
The Small Block Chevy has 2 flywheels and 2 starter noses.
153 tooth and 168 tooth
Offset bolts and non-offset bolts (these are the mounting to the engine bolts)
The LT1's and at least the 93 L05's (likely more) have a 153 tooth flywheel, with non offset mounting bolts. I am betting any 90-92 Chevy powered Cadillac can also use the PG260M. But you need to check.
You CANNOT use the PG260 from the Tahoe/Suburban/Trucks. This one is for the 168 tooth flywheel and the offset mounting bolts.
There are a few starters out there:
5MT/SD250 (direct drive, no gear reduction) old school direct drive, very heavy. ~20 lbs

10MT-direct drive, no gear reduction, this is the old "big block" starter, very very very heavy! ~25 lbs (gotta confirm the pict here on the 10MT)

PG250-Planetary gear reduction, 1.4kW, I believe a 4:1 gear reduction ~10 lbs. Note no visible bolts mounting the solenoid, and NO bolts outside the sides of the motor

PG260M-Planetary gear reduction, 1.7kW, 4.4:1 gear reduction ~7.7 lbs. Easily ID'd by the 2 long outside of the motor bolts.

Corvette Mini Starter (can be used, not discussed here, often expensive, but very light)
So, in summary:
As long as you keep the right flywheel and right mounting bolt offset, you can almost always interchange these starters as long as they physically fit.
Most of this info applies to traditional Buick V8's also (350/455), and most likely the V6's in rear drive configuration. The Olds and Pontiac V8's have starters on the opposite side of the blocks and none of this applies (sorry! I have a Pontiac 400 that I wanna drop on a gear redux starter!) Aftermarket has them, but the costs are pretty steep.
I do believe this is a good starter for the Cadillac 4.5/4.9L V8's. But I think the starter is clocked the wrong way (Olds/Pontiac clocking). I have never been under a Cadillac Big Block (6L/7L/7.7L/8.2L), so I can't say on those.