[Feature] Enhance return result for procedure

### Search before asking

- [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar.

### Motivation
Enhance return result for procedure.
- [x] compact
- [x] rollback/rollback_timestamp/rollback_watermark
- [ ] compact_manifest

### Solution

_No response_

### Anything else?

_No response_

### Are you willing to submit a PR?

- [x] I'm willing to submit a PR!

Start by locating the procedure implementations for compact, rollback, rollback_timestamp, rollback_watermark, and compact_manifest. Compare the current return results for the checked procedures, then determine the expected enhanced result and verify that compact_manifest is handled consistently.

Written by the indexing model from the issue text.