I've been reading up on the trans and how they won't hold up to being modded.

As far as engines go, I've only heard of blown headgaskets from all this tuning? Surely there's gotta be a cost to the engine than just that. Are they're any other mechinical engine failures?

Stock turbo can be killed is you boost it too much, but I have not heard of many engine failures.