Just to add as a side comment that the prefixed form in theophoric names is either yhw/yehô or yw/yô. Several names are found in both forms, e.g. Yehochanan/Yochanan, Yehoyada/Yoyada, Yehoyakin/Yoyakin, Yehoyaqim/Yoyaqim, Yehotsadaq/Yotsadaq, Yehoram/Yoram, Yehoshaphat/Yoshaphat...
"Hallowed be thy name" has an excellent rabbinical parallelism in the Qaddish, which shows that such an expression was quite compatible with the (equally rabbinical) belief that the Tetragrammaton should not be pronounced.
From a historical perspective, Yhwh as a vestige of polytheism (where it was actually used as the name of one god among others) became a quite embarrassing feature in monotheism. Only different sections of Judaism dealt differently with the problem. One solution was to treat it as a hyper-holy name and ban it from common use, at the risk of relegating it to underground magical use (if it was such a holy name it had to be powerful); and there are indeed traces of magical uses of Yhwh; another was to interpret it theologically (as Exodus 3 does). Philo almost feigns to ignore its existence, considering "Lord" to be the name for all practical use and "I am who I am" as a mere refusal to reveal any name.