John, 3d printing is indeed fun - and despite what one sometimes reads, useful.
Generally, the articles that say that 3d printing failed to live up to its promise note that people thought they had a Star Trek replicator that would automagically print whatever they needed ... and then they discovered that 3d design requires work.
More about this below ...
I am happy to share my thoughts on 3d printing, with the understanding that this represents only my own experience and needs; mileage may vary. First, thoughts on filaments:
1) PLA is actually stronger than you may think. It is easy to dismiss it as a "beginner" filament, but really, it is quite versatile and reasonably strong. Its one great weakness is that it can deform at relatively low heat, so don't plan to use it for a part that lives inside a hot car, for example.
2) PETG is a nice all-around filament. It is softer and more flexible than PLA, so one might think in terms of PLA being strong but brittle while PETG is more tough and flexible, with better performance in hot environments (though only relatively better than PLA - it might survive the hot interior of a car, maybe, but nothing hotter than that).
3) ABS is not as hard to print as you may think, IF you have a heated bed that can go to 100°C AND you use "ABS glue" (a thin solution of some ABS dissolved in acetone) to wash the plate. But it has poor UV resistance, is smelly when printing (potentially dangerous fumes), and in general I have not found a reason to use it over PETG or PLA.
4) Nylon seems like such a great idea - it should be super tough, great for wear parts - right? Well ... the first problem is, a stock Ender 3 or similar printer is not going to print it successfully. Nylon WARPS like mad; even with a 100°C heated bed, it is nearly impossible to print anything other than a very small part without corners lifting and the part warping - unless you have a heated enclosure, which I do not. Add to that the fact that Nylon loves to absorb water, changing dimensions in the process, and I decided that this filament was not so great after all.
5) POM aka acetal - the common trade name is Delrin - again, seems like such a great idea. I LOVE to use Delrin in machined parts for strength, stability, low speed bearing surfaces, and more. Printing it is ... challenging. Even worse than Nylon, POM is near-impossible to print without a heated enclosure. I have had some success with small parts, such as a linear bearing printed in "vase mode" or a small bushing for a wheel.
6) TPU - flexible filament - I have had success in printing both 85 and 95 TPU (the number referring to how flexible it is). The conventional wisdom is that it requires a direct drive extruder ... but I have been successful with a Bowden extruder. The key is a custom-designed extruder that completely constrains the filament path so that it cannot "squirt out" around the extruder gear. Also key - to either Bowden or direct drive - is greatly slowing down the print speed.
Note that some (most?) of these filaments need an all-metal hotend; depending on the nature of the bed, some of these benefit from some sort of stick/release layer (e.g., glue stick); in particular, without glue stick or similar, TPU can stick so tightly to the bed that it will not release without ripping up chunks of the bed.
Note also that there are tons of variations on many of these filaments, and some of those variations can make a significant difference in strength and/or stability - a particular example being carbon fiber added to the filament. But note also that many fillers, such as carbon fiber, are abrasive and will require the use of a hardened nozzle for best results.
This is getting way long, so I will continue in a second post.