I too have been trying to pin point what to use in my Honda transmission (S40). There is no real golden lube that will make every Honda transmission feel perfect, you will have to experiment for yourself, every transmission has worn differently, but as long as it is a 30 or 40 weight oil the transmission shouldn't die because of a certain fluid.
Food for thought, the new Honda MTF they sell is nearly a 20 weight oil to try and wring out a little more MPG, which can cause shifting issues to appear in our older transmissions, if you can find the old spec Honda MTF grab it all. I had a fill of the old stuff, it was great, got the new stuff for my change last year and it was notchy and like sorting though a bag of coconuts. I have tried nearly every synchromesh product on the market, even the boutique synchromesh, but not RP, currently Pennzoil syncromesh is giving me the best results I have had so far.
I'm curious stro was it just Amsoil XL?