In my case, I use Atuin. It has a concept of "context" so you can easily search the history for commands related to your current directory / project / etc. See [0] for some examples.

Now, I admit I don't use these that often, but they can be useful.

It also does stats and whatnot based on the history. I've never looked at those.

[0] https://docs.atuin.sh/latest/guide/advanced-usage/