The average life span of a crypto currency is 1.5y so, a lot of them will fail during this time period.
The "magic" is to try to weed though the clutter and select the ones that will have higher chances of survival otherwise, like you said, the resources available to you will be wasted.
I personally don't regret the time & resources I spent mining altcoins even if they weren't successful in the end because that contributed to improving my knowledge in this field.
I think the average life span is an interesting statement. A lot of the coins in my consciousness have been around for nearly 5 or more years but I constantly see coins in coinmarketcap that I've never even heard of.
Totally agree about the "magic". It really is like magic when you finally realize a coin you have been interested in indeed turns out to be relevant and successful. My aim when choosing a coin is to answer if what they are doing is something that I would pay money for or if it is relevant for business operations. Crypto is creating a lot of business value and there are many "holes to be filled" now that various things like VPS hosting are more important than ever. Now, think about this... not just NVidia (stock)... not just Bitmain (IPO coming) or Xilnix (stock)... it's not just these guys getting more business, profit, and of course likely higher stock prices... it is also the infrastructure that goes into data centers. Yes, more profit for the Cisco's, Palo Alto's, HP, Dell, etc etc etc. OH... well... uhh... this also sounds like the perfect build up of that bubble too! Because once all these resources go into it... there will be many projects that simply fizzle out. Will it be enough of a bubble to be memorable? Do people still recall the dot-com bubble? Was the dot-com bubble really all that important since we have moved on? Yes, of course to those people who lost retirement savings.
Yes, the learning experience here is truly exciting. I find myself learning things from the architecture of CPU/GPU/MOBO to some basic Linux commands, VBS, and some other stuff and of course I realize I really want to learn something better like a programming language or 6.. lol right... in my dreams