I just bought some Gates brand trans oil cooler hose from Oreilly, it was for an oil cooler on an engine.. Was about $6.49/foot that was 3/8" inner diameter hose. I agree, I wouldn't buy that huge spool of 25ft, that's crazy. But ya Napa being the most expensive doesn't surprise me, they always do that. And Autozone is doing some odd recommendations lately, actually had an Autozone manager argue with a friend of mine over using transmission oil cooler hose on (of all things) an actual oil cooler! lol.. something odd over there I tell ya!
yup you're thinking is correct, don't let Autozone confuse you, they're the ones that are confused.