The furore created by Musk's erratic tweets could leave investors out of pocket, but could also bring new eyes to crypto in the long run.