Performance monitoring of manifest cache

### Feature Request / Improvement

## Description
As discussed in #2993, it would be nice to have a function call similar to `cache_info()` to get information about cache hits and misses

## References
[`cachetools` implements a 2 counter to achieve this](https://github.com/tkem/cachetools/blob/5dce86fc5c9c565c6e9c912e2be5d6abb9586a1d/src/cachetools/_cached.py#L17)

Start by reading issue #2993 and the referenced cachetools _cached.py implementation, then locate PyIceberg’s manifest-cache entry points and any existing cache_info()-like API. Done means the manifest cache exposes useful hit and miss information through a function call, with behavior aligned to the agreed design.

Written by the indexing model from the issue text.