For example, the ‘tension and release’ of Dsus4 to D major, or even a V-I progression such ... this within a minor 9th chord, ...

Complete mastery of the fretboard – as much as such a thing may be possible – would have to include knowing each and every way a chord can be played or ‘voiced.’ Taking a theoretically ...