I might also clarify that the Tetragrammaton can not be translated, but attempts can be made to transliterate the Name. Most translations have opted (for various reasons) to signify the Tetragrammaton by all-caps LORD and on a few occasions GOD. Where Adonai is translated Lord and Elohim God/gods. I hope these notes are helpful...
I'll take the clarification of the name of the Almighty God for 1000 Alex

Your absolutely right, the Hebrew Tetragrammaton cannot be completely translated into English (or even modern day Hebrew for that matter). This is because vowels did not come into use in Hebrew until the second half of the first millennium CE.
There can only be a couple reasons why one would choose to remove (New KJV, Latin Vulgate, Catholic Douay for instance) the name of God (there almost 7000 times in original manuscripts) from the bible (even if just for putting the Tetragrammaton in place of it; not represent it with a title). Either the translators have purposely removed the name of God from the bible for greedy means, for instance they have done so by trying to fit the bible to their own theology, or because of superstition in using God's name (perhaps feeling it's too sacred to be spoken; although none of God's people ever felt that way in the bible) or because of "tradition" (of men) passed down from when the Jewish religious leaders started doing it in the first or second century CE.
His name severely outnumbers the titles applied to him; such as "Sovereign Lord" or "God". If we were to deny the transliteration of God's name then we'd also have to change the "English" names applied to Jeremiah, Isaiah and a slew of others. No doubt these are accepted as appropriate names? When my name is translated into Spanish it changes to Christobal, I don't see how this is any different.
Using God's name (not a title, but YHWH, Yehwah, Yehwih, Yehowah, Iabe, Iaoue, Jehovah) was a command by God to be used by Moses when he was to meet with Pharoah at Exo 9:13,16 "Then Jehovah said to Moses: "Get up early in the morning and take a position in front of Phar'aoh, and you
must say to him, 'This is what Jehovah the God of the Hebrews has said"..."But, in fact, for this cause I have kept you in existence, for the sake of showing you my power and
in order to have my name declared in all the earth". How could God's name be declared in all the earth with a title? Even the President uses his real name, then again so does Satan.
Psalms 113:3 says "From the rising of the sun until its setting
Jehovah’s name is to be praised". How could God's name be praised if it's unknown? And how could Isaiah's words be fulfilled in Isa 64:2 where it states "as when a fire ignites the brushwood, and the fire makes the very water boil up, in order to
make your name known to your adversaries, that on account of you the nations might be agitated!"?
Reasoning on what is found at James 4:8 it says "Draw close to God, and he will draw close to you. Cleanse your hands, you sinners, and purify your hearts, you indecisive ones". I doubt any one of us in our personal lives have any really close friends that we don't know their real names. Abraham was counted as being God's friend, 2 Chron 20:7 says "Did not you yourself, O God of ours, drive away the inhabitants of this land from before your people Israel and then give it to the seed of
Abraham, your friend, to time indefinite?" Abraham also used God's personal name when talking with him, drawing close to him as a friend. We can only draw close to God, as Abraham (as many others did), by using God's personal name.
However much I enjoy this thread, methinks it'll be locked soon... I'm just waiting...