I had just the same issue creaking noise front wheel driver side, I used a very small needle wd40 and grease(mixed) and injected thru the rubber, the noise was gone immediately. and sealed with silicon with fingertip(I cleaned the rubber first), this will seal the tiny hole(not necessary if the needle was tiny...)

Question:
for those who has done this earlier, will the creaking sound come back? if so, how long did it last before the sound come back?

I did it almost two years ago.

However, it's gotta be tied to mileage and heat and humidity and water penetration and probably one or two other factors as to how long it lasts.

Frankly, if I had to do it every three months I'd still think it was a great cheap fix for something that's still quite functional but just noisy.

I just replaced my front lower control arms and tie rods
I had cracked boots. For the past year+ I had "The Noise" coming from there. Every 3-6 month I would spray WD-40 in and that kept things quiet.
What I observed when I took out the old control arms is that the ball joint that I applied WD-40 to, was very easy to move around. The other old arm, I did not spray, was vary stiff to move. The new replacements arms have very stiff ball joints.
I think the WD-40 is a temp fix if you are planning on replacement. I also now think that once you start the WD-40 regiment, it's just a matter if time
Again, my boots were in pretty bad shape so I'm sure that was a contributing factor. The thing is the old arm that was stiff also had a cracked Boot but didn't creak so I never applied WD-40

Injecting Lithium(thin) or other grease is probably better as it will stick to the moving parts better and stay where its needed to continue its lubrication.

WD40 will leak out quickly and need to be reapplied often.

I started to get a little drivers side creaking on my 2000S with 123K miles. I injected a little lithium grease while I had the tire off during a brake pad change.

I've put about 1000 noise free miles on....so far so good!