While Profiler lets you capture the show plan in XML, I don't believe Profiler displays it ... the URL in the answer gives a description of the Profiler benefits, but...

Yes, you can use a return code to return data.

But just because you can, doesn't mean you should!

I agree that this is a new Worst Practice, and should...