Explain middleware pipeline execution in depth

Middleware executes in order for requests and reverse order for responses.

Each middleware calls the next delegate. Response flows back in reverse order, enabling pre/post processing.