I've been daily-driving a 900T for over a decade and it suits me just fine. My 89 recently rolled 200k and runs like it always has. The hatch is huge, and they're fun to drive. Years ago I added a ton of extra boost cuz it's fun and cheap; no problems yet.
They kick ass in the snow (I do some winter time-speed-distance rallies in an '85), but they're not magic, so don't think you'll be able to use your summer tires. (I'm using cheap but awesome General Altimax Arctics, which are an old Gislaved snow tire that's been rebranded -- they work as well as Hakka 2s, though they are not top-of-the-line.) They're actually better in snow if you pull the front sway bar, but that's a bit of a PITA.
85-86 SPGs had no more power than standard Turbos (160hp), and had the same suspension, too. 87-91 SPGs got lower, stiffer springs and different shocks, and more boost. 87-89 had just a few hp more (10-ish??). 90-91 SPGs had the most power of all SPGs (175 vs. 160 std Turbo). (In fact, the 93-94 Commemorative Editions, which weren't SPGs, had the most power of all c900s: 185.) But, as noted earlier, this doesn't matter. You can take a 160 hp Turbo and add 25 hp for about $20 and a trip to the pull-a-part.
89-90 transmissions were the best, but all years are not strong. 91+ had crappy synchros; pre 89 had smaller pinion bearings. If you abuse them, they will thank you by crapping out on you.
88+ have better brakes than earlier years, which had an annoying front e-brake. 90+ have ABS (and airbag).
90-91 SPGs had a smaller Mitsubishi turbo than the T3 fitted all other years. In 91, all run-of-the-mill Turbos got this Mitsu as well. Closer in size to a T25, the Mitsu makes a difference with lag. (Incidentally, the Mitsu has a T3 bolt pattern.) You can easily tweak the timing to improve off-boost performance, too.
Finally, these cars have a double wishbone front end that is easily adjustable with shims from the pull-a-part.