From a Psychological viewpoint, is there any mental health benefit in believing in God?

Sure, but only if you don't want to explore the "unexplained" and try to understand it for yourself.