I can't confirm whether this is common or uncommon issue. The hinges on my 2000 are silent and I have never read another post describing the problem so I am going to speculate that it is uncommon. But, as the cars age things change.
WD40 is sort of useful for penetrating; but, not very useful as a durable lubricant, particularly in high load areas like the pivot on the hinge pin. As a Hale Mary, I might be inclined to try washing the hinge pin area with solvent (brake system cleaner might be an option) to get everything clean, then try applying a low viscosity oil directly to the pin area. Something like the 3 in 1 electric motor oil or perhaps some 0W8 motor oil.
The service manual and the parts diagrams show the hinge as one piece - no separate / separable hinge pin and more importantly no replacement retainer for the hinge pin. However, when I look at my hinges, the pin does appear to have a straight forward C clip retainer that should be removeable. You should be able to confirm this by cleaning off your hinge with solvent and inspecting. The best part of the C clip is if you break it during removal you should be able to source a new one.
With the C clip removed you should be able to extract the hinge pin, clean it and lubricate it with a heavy bodied grease. The obvious way to do this is to remove the doors from the car to allow easy access to the hinge. Honda dedicates a whole 4 steps (about 50 mm of column space) in the service manual to door removal which kind of implies that it might be fairly easy. However, anybody who has ever worked with the doors or even giving close inspection will reveal that this 'ain't going to be no Saturday afternoon party'.
The hinge pins on the top hinges are inverted and have their C clip on the top. As long as you support the weight of the door so it does not droop, with the door fully open I think there is enough space to access the C clip for removal and then force the pin out from the bottom so that it can be cleaned and lubed. The bottom hinge has the C clip on the bottom of the pin and I don't think there is access from below to R&R the C clip.
@Honcho or
@drew have probably been through this so they may be able to advise on the feasibility of accessing the hinge pins with the door 'in situ'.
Outright replacement of the hinges will require complete removal of the doors because without some kind of magic wrench with 5 flex joints I don't see any way to access the bolts that hold the hinges to the body with the door in place. The service manual does not explicitly address hinge replacement; but, from what is in there it appears the steps are; unbolt the door from the hinges, separate door from car enough to allow access and then unbolt hinges from the body. Replacement of the hinges would be my last resort because new hinges will not be color matched to the body. If you want color matched you will need a local paint shop to do that for you.
I would try really hard with cleaning the hinge and applying a lower viscosity oil of some kind to the hinge pin. All the other options are going to be a lot of work / much more expensive if you don't do it yourself.
