The thing I still don't understand that I'm frustrated by the most is the origin of bitcoin's value

Here is an excellent article from 2014 by Jeffrey Tucker:
https://fee.org/articles/what-gave-bitcoin-its-value/