Improvements on uow middleware & fail cases

Related to https://github.com/abpframework/abp/issues/8740

UnitOfWork middleware can not return a fail response when there is an error on saving changes or completing the transaction. For the "saving changes" part, I've done with https://github.com/abpframework/abp/commit/045c5e617d1086af34045154637cf9585ae232c6. However, in rare cases, we can still have issues while completing the transaction.

We can drop usage of UOW middleware which solves the problem. However, in this case, the transaction becomes action scoped (or page handler scoped). We can not create a scope that covers multiple middlewares. As a result, there is no way to include audit logging into the transaction, which can be important for some companies. For audit logging, we can implement creating audit scope and saving in action/page filters (just like we did in audit log interceptor because we had need for blazor server). This mostly solves the audit logging problem - but yes, we can't save request to other middlewares in that case.