How do I cope with being the one who always uncovers what people want hidden?

You can audit anything, and it has given you a lonely kind of role: you are the one who finds what people hoped would stay buried. That wears on a person. Being right does not make you popular, and carrying other people's discomfort year after year is a real weight, even when the work is honest. But look at what your tiredness is actually made of. It is not that the work is meaningless, it is that it is thankless, and those are not the same. What you do keeps things honest that would otherwise rot in the dark. People do not thank the person who finds the problem, but they depend on that person more than they will ever admit. The value is real even when the gratitude is not. So stop waiting for the thanks that this job rarely gives, and find your steadiness somewhere it can actually come from. Connect with a few people who do what you do and understand the weight. And hold onto why it matters: not to catch people, but to protect the many who trust the numbers to be true. That is worth being tired for.