I have a library with about 300-500 different capacitors, not 1. You need to fill in everything by yourself, for every capacitor. It is not easy, nor rewarding, maybe the company you work for should hire a data-entry person to do it, or hack something in excel.
If you take the excel route, then comes the hard part, the components need to be linked some real components. This means manufacturer code or digikey code, whatever.
For opamps, you can set the default in the library. If you lock the "part" field, that means that part A will always stay part A, even if the components is re-annotated.