I can use SQL Profiler and view SQL Text with parameters. When we have an issue a lot of times it is not the query but rather the data inside the query is corrupt or too large. Without seeing the stored procedure parameters we cannot track down which record to look at. When you have no privacy concerns like medical, financial or any other personal identifying information, it would be great if that information was not hidden. An advanced setting "Show SQL Text Parameters" default set to NO, but users ability to set to you would be amazing.
What we have to do now is when there is an issue, which is rare but happens, we run the blocked monitor, and SQL Profiler, match up the SPID and look at profilier for the information we need. Most the time you do not have the luxury of being there in realtime, you are looking at historical data.
Please upvote or let me know your suggestions.