In all honesty though, as a connoisseur of fixed camera angles, Kuon's camera angles aren't that amazing most of the time. The game's environments are fairly open and empty so the angles are mostly pretty pulled back and utilitarian, more focused on giving you a clear view of each area rather than setting a mood with creative shot composition like your Resident Evils and Silent Hills. The game reminds me of Silent Hill 4 which had a similarly detached camera to go along with its larger, sparser environments.
Despite the kind of simplistic gameplay and repeated puzzles and progression during its two campaigns I'd recommend Kuon if you're into PS2 horror and traditional Japanese ghost stories
Fixed camera angles were never good, just a technological limitation that a very specific age bracket of gamers are nostalgic about
Not every game needs to be in first person or have an over-the-shoulder third person camera because not every game is an action game where you need complete spatial awareness at all times