Waits can be viewed at an aggregate level on the server, and on an individual basis for executing queries. Duration and worker time and IO are tracked for query executions. But I'm not sure you can see the specific "why a spid was suspeded" details like you want at the individual execution level for non-currently-running queries.