During a CSU warranty, I switched from 51 to 44 offset on my previous Chromag Rootdown (64 degree head angle). There's lots of talk of things like trail, but I mostly noticed the difference in front-centre. The long offset fork made the bike feel more raked out, similar to a slacker head angle. The short offset made it easier to get the front wheel to bite in corners, likely as a result of having the contact patch farther back and closer to my centre of mass.
One the flip side, I had a 2019 Devinci Troy with 170 mm 42 offset Lyrik, putting the head angle around 65. Coming off my previous Norco Range 29, which had a 65 degree head angle with 51 offset fork, the Troy felt a bit twitchy, like the front wheel wanted to tuck under in corners. My hypothesis after that is that the shorter offset pairs well with a slack head angle. The discussion in this article does a pretty good job at summing up what I felt:
https://nsmb.com/articles/2018-ibis-ripmo-reviewed/
I don't think one offset is better than the other, but there are definitely noticeable differences.