Hmmm. Some good advice here but also several points that are completely wrong.
1. In general, yes, slinky loops will require more feet of pipe for a given set of conditions (load, soil type, climate) than other configurations. The energy absorbed by a loop field is a function not only of the total length of pipe in the ground, but also how the total area that the field can draw from. For a given length of pipe, denser configurations will not perform as well as a more spaced out layout. That is not to say that a properly designed slinky won't work - they are a very popular design and most work just fine. As you said, pipe is cheap, so generally increasing pipe density while decreasing excavation costs will save money. It needs to be properly designed for your system and conditions - don't go by rules of thumb. Also, slinky configurations are slightly more difficult to backfill properly - this is critical to good loop performance. Again, not a problem if you know what you're doing.
I would absolutely expect the loop temperatures to drop below freezing at the peak of the season in most heating dominated climates - this has nothing to do with the type of loop, it is just the way most horizontal loops are (should be imo) designed. As the ground freezes it gives up latent heat, which helps keep loop temps near or slightly above freezing. Try to find a Canadian geo guy to ask about this! As your guy said, for this reason you don't want the loop field too close to the house, 10 ft sounds like a reasonable number. Again, proper design for your particular situation is critical. You need to make sure you have enough heat gain in the summer (solar, groundwater, ac loads) for your loop field to recover.
2. I will say that an outside manifold is common practice and makes the indoor plumbing much simpler and neater. It is a fine way to do it. HOWEVER, there are also strong points in favor of indoor manifolding, espscially for the DIYer. All outdoor connections should be fusion welded for reliability, period. I think you mentioned barbed fittings and hose clamps above - don't do it! A loop field filled with methanol or other antifreeze 6 feet down is a little more problematic than a water line to a hose pipe if one of the connections should fail. This is just about the only point I've ever seen virtually every geo guy agree on - only fusion welded connections underground. So, if you don't want to rent a fusion welder and get trained on how to use it, you need to bring your loop ends inside so there aren't any joints underground. The other advantage is that you can valve each loop and if it is set up correctly (Again, lots of other design considerations here) you can fill and purge the system with the loop circulator - otherwise you need a purge cart. Also if you do develop a leak, that loop can be isolated leaving you with partial capacity.
The biggest drawback of indoor manifolding is, as your guy said, the difficulty in insulating the assembly. It is by no means impossible, but it is fiddly and labor intensive. I have no idea where he got the idea that the manifold will take a significant amount of heat from the house. Maybe if you set it up in the middle of your living room with no insulation and a fan blowing across it! If I feel ambitious I'll do some calcs tonight to show how ludicrous this statement is. Pipe sweating is really the only issue to be concerned about and as I said it is simply a matter of insulating properly which CAN be done. Also, indoor vs. outdoor manifolding is a completely seperate issue from what type of loop field you have.
Getting back to your original question on where to find pipe, most installers will spec "geothermal" HDPE, which as far as I can tell is virtually identical to regular HDPE but is manufactured to a higher standard and has a longer warranty (50 years in some cases). It also comes standard in longer coils, is marked by foot, and is usually pre-pressurized so you know as soon as you cut the end off that the coil has maintained its integrity. Will regular water HDPE work? Probably, but in most cases the pipe is a pretty small part of the system cost, so you might want the peace of mind of using the real "geo" stuff. Eagle Mountain (radiantmax.com) sells geo pipe, but shipping might be a killer as you said. Note that pipe speced for geo systems is typically SDR11, which is an OD-controlled pipe. Barbed fittings designed for regular HDPE water pipe, which is ID controlled, will fit too loosely to get a good seal. I found the barbs would work for testing with a double hose clamp, but I'd never trust them as a permanent solution.
Hope this helps somewhat - keep doing your research and if at all possible at least get a pro to consult - the pipe is cheap but you don't want to be digging it all up in a year!