Another aspect to consider is the term " invention is the mother if necessity" coined by Jared Diamon, in contrast to " neccessity is the mother of invension". A lot of technology either get discarded or used for something that the technology wasn’t originally intended. Hence the idea that inventions come first and the necessity for them follows later. Targetes technological innovation tenda to be very expensive and involves a lot of trial/error.

I believe this phenomenum doesn’t just apply to big innovations and inventions. It also applies to day to day problem solving and in your case, choosing the right technology for your work. Without prior experience and established norm, a technology that might completely makes sense to you for a certain kind of work, might not pan out in actual use.