I entirely agree.  In fact, I've just returned from a T-SQL course with Learning Tree and so am very pro T-SQL at the moment.  I think in the interim it'll be a case of finding my (and everybody else's) feet to discover which procedures are going to perform better depending on what language they're written in.