Improve reporting RPM errors

[jan-kolarik]

This is a follow-up to the original dnf4 request from https://bugzilla.redhat.com/show_bug.cgi?id=2312906.

Sometimes we report a generic RPM error, even though RPM can provide a more detailed, descriptive message.

[3/4] Upgrading filesystem-0:3.18-23.fc41.x86_64                                                 100% |   1.5 MiB/s | 212.5 KiB |  00m00s
>>> Unpack error: filesystem-0:3.18-23.fc41.x86_64

Transaction failed: Rpm transaction failed.

While with the old yum:

"unpacking of archive failed on file /media: cpio: lsetfilecon"

Related: https://bugzilla.redhat.com/show_bug.cgi?id=1878057.
Related: #849 (comment)

[ppisar]

Duplicate of #1710.