All EFI cranks and mains (turbo or not) are the same until about 93 or so, at which point they changed the mains to a smaller journal. The rod bearings are the same though, so if you wanted, you could drop a set of turbo rods and pistons into a small journal motor and effectively have a 2.3 turbo shortblock. Some people say the turbo blocks have more nickel, but I don't think it was ever proven one was or the other. Either way, it probably doesn't matter, since you'd be making silly amounts of power before you ever needed to worry about that.
The stock pistons are very good, and Michael is the only person I've ever heard of who's had such problems with the skirts. The stock rod/piston combo has pressed in wristpins, and the rod bolts seem to be the first thing to become suspect when you really start to lean on a stock shortblock (~350 whp).
Turbo heads don't have their own port design, but the chamber is a little smaller, so it will raise your compression unless you rework it a little (or adjust your tune - which I think would be a good idea since the stock compression is pretty low at 8:1). The turbo motors have excellent Inconel exhaust valves, which will go right into a non-turbo head. The stock heads DO crack a lot, but don't scrap one because it's got a hairline/trace between the valves - get it pressure checked.
You can also use early carbed motor heads. Those have slightly different ports, but the chambers are identical to the turbo motors, so it's actually an easier swap than using a non-turbo EFI head. And since they had mechanical fans, it's easy to find non-cracked ones (I think faulty fan controllers on the EFI cars caused the turbo heads to crack).
As for eating cams and followers, again, I've never seen it happen. In 11 years of playing with these, I've never had those issues.
As for being heavier than an LSx, yeah I'm going to call BS on that one. I've had both, and have had to move both, so it's not like I'm just pulling that out of thin air. Yes an LS motor is aluminum, but it takes a lot of aluminum to make a V-configured motor strong.
The 2.3t is one of the best grassroots motors out there. Good power, easy to mod, strong, CHEAP, super common parts. But yes, it's heavier than the newer stuff.