I went back to back on the same bike with the same pike 140, just changing the uppers from a 51 to a 42. I think its a big difference, and so far I havent noticed any drawbacks. The changes to steering geometry more than make up for the shorter wheelbase/front center. and that shorter front center is an improvement in tight situations, with no drawbacks i can feel from the steering gemoetry side. hard to imagine a bike i wouldnt like this on.
In terms of climbing, the 51 would feel twitchy in a way that made it hard to be accurate, had to focus a lot on keeping the front wheel straight and not letting it wander, tight switchbacks if anything felt easier, i dont notice it being "harder" to turn the wheel, effort wise its a small difference if anything, but it feels more controlled and accurate, Im wondering if the contact patch being that 9mm closer is helping to get around tight stuff as well.
As far as descending this is where it made a huge difference, the bike doesnt feel vastly different in any way, you could hop on either not knowing what the offset is and immediately feel comfortable, even riding hard 10/10ths, theres no one huge change. its a lot of small changes though that add up to a big improvement.
Straight line point and pray style stuff, it tracks much better, you dont have to worry as much about a rock taking your front wheel and sending you off line, the fork wants to track straight through that stuff. so if your line is less than ideal, or you dont have a good option, the front remains mostly composed and predictable. On the same fast, straight, chunky sections of trail with the 51 offset, if I felt myself straying off line and heading for a stray rock, id go for the brakes or half panic because i knew it'd likely throw me off line in a sketchy way.
In corners, similar deal, you lean the bike over and it wants to track through the corner, mid corner bumps dont upset it nearly as much, and the harder you work the front end into the surface, the better it hooks up. With the 51 offset, same corners, Id have to alter my line to avoid rocks mid corner that could potentially grab the wheel and turn it, which might tuck the front and throw you over the bars or wash out the front. When getting up over the front, trying to force the front tire into the ground, it felt like a guess if it was going to give you more traction, or wash out, tuck the front, etc.
I also noticed with the 42 offset its easier to lean the bike and keep it leaned, which i wasnt expecting, from an article i read on offset, I thought lower offset would be more "self correcting" and want to right the bike up to straight. Which might technically be true, and if it is, it wasnt in a way that i couldnt overpower physically. but it feels much more composed and easy to be confident just throwing the bike into a corner with a lot of lean and knowing it'll hook up, the bike doesnt do anything funky. With higher offset you can get this kind of uncertain feel from the bike, even if you lean it with confidence and throw it into a corner like you should. Its so much more sensitive to things like steering input, shifting weight, mid corner bumps, etc. it can throw the bike off, thus throwing you off, you get slightly hesitant, you're more likely to commit less.
Similar deal with off-camber lines, you can demand more from the front and have confidence it'll take it. where with the 51 you'd have to get a little defensive and not ask too much, or hit it a little slower.
In terms of steering quickness, I dont notice it being "slower" in any negative way. if i want to make a quick direction change, move the bike around, weave through some awkward line i can easily do it, I'd almost say its easier because you can do it with more confidence and "tell" the bike what to do. where those same situations with a 51 offset, it was so twitchy id constantly be worried about asking too much, it almost took more mental/physical effort making sure i wasnt going to ask too much of a steering input.
Downhill tight switchbacks, again only an improvement, but not as noticeable, its slightly less likely to tuck and throw you forward, and i've noticed i've been cleaning some tight switchbacks easier than i had before, which could also be due to the shorter front center/wheelbase.