If you have unlimited memory, network bandwidth isn't a problem and the additional garbage-collection won't kill your performance.

News flash: your database server doesn't have unlimited memory either.

About network performance - if you have such a large result set that you're worried about network performance, than the sorting work in the database is going to be very non-trivial as well. App servers scale out inexpensively - SQL Server does not.