Does it make this noise when driving around a tight corner or turning at a junction? Your description is pretty vague.
If it's predominantly when turning one specific direction it's likely to be a CV joint. None of your magic bottles of oil are going to fix that one if it is.