Generally, in GUMSHOE, the "auto-success" aspect of just HAVING an appropriate investigative ability only applies to obtaining information that's necessary to advance the plot.
The benefits of investigative SPENDS varies by game (and genre), but will usually give you something "extra"...