In Poul Anderson's Tales Of The Flying Mountains (New York, 1984), the theme of "Nothing Succeeds Like Failure" is the unheroic origin of gyrogravitics and the theme of "Recruiting Nation" is the unheroic origin of the interstellar expedition. Anderson also wrote heroic fiction, however.
"Recruiting Nation" has two moments of realization.
"The drink leaped from my hand and splashed across my lap." (p. 276)
That is when a remark about programming computers alerts Sanders to a scam on the ship.
"An answer hit me, hard as the original solution had done. I sat straight in my chair and barked a delighted oath." (p. 281)
That is when Sanders realizes how he can make the miscreant confess. Sanders is an Andersonian problem-solving hero.