Another bump for this thread because I finally beat this game.
I really enjoyed it and, like others in this thread, hope they come out with another. As per all Yakuza games, it could've used some editing but I wound up feeling pretty happy with the main narrative despite the bloat. Combat needs more variety and fewer encounters (both in the open world and in the story). I haven't played Yakuza Like a Dragon yet and I'm curious if making it turn based would've made it better or worse.
One of my biggest gripes is the mortal wounds system. Too easy to get randomly wounded while trying to do something else and the only cure for it (as far as I knew) was in one far corner of the map.
Loved the characters and the detective-related gameplay bits (thought it was so cool that they had different mini games for different types of locks). If they make more, I hope they lean more into being a detective vs. a brawler.