I tend to rest the fingers of my picking hand on the guitar body, right near the PU's, so I have trouble picking anywhere but between them, so I can sort of feel where the bridge PU is, with my fingers. I find that if I intentionally move up (towards the nut) out of my "comfort zone", to get certain pinch harmonics, the bridge PU quickly affects that, sort of, getting in the way. So for that use case, having that extra room btw them may be a benefit.
But after getting my first 24-fret guitar, a PRS Custom 24, I found I just prefer having the extra notes available. I play a couple solos that have quick slides up to the 20th, 21st, and even 24th frets. Having the extra room a 24 fret neck has is helpful in those situations.
Does anyone know who first built a guitar with 24 frets? I think it mainly comes down to what you play, note-wise, and whether you can tell, and prefer, the difference in tone of the neck PU, depending on its placement. I didn't know that about SG's.