<Forgive me for asking such a fundamental question>
I have just finished reading a 200 page book on Light and Vision (the old Time-Life series), and can assure you that while the question is fundamental, the answers took more than 300 years to solve (from Isaac Newton in the 17th century, till the 20th century molecular biology).
<but even though I have been told, and accepted the fact, that the primary colors of light are red, blue and green >
Light is part of the continuous spectrum of electromagnetic radiation. The fact that humans see 3 primary colors is a function of the 3 rhodopsin pigments in the eye, and is not inherent in the spectrum of light itself. A different multispectral system was used for Landsat images, and had to be converted to false colors for display on maps.
The brain fills in the rest of the colors to create the appearance of a continuous spectrum. The red and green wavelengths preceived by the eye are closer than Dan Sapper indicates. About 8% of males have difficulty distinguishing red from green (color-blind).
A rainbow or prism is the best example of a continuous spectrum. If the light source changes (e.g. gets redder at sunset), the appearance of the rainbow will change (the blue end vanishes).
Not all light sources have the same quality or color balance. Incandescent lights (tungsten) are yellowish, and needs a slight blue filter when used with ordinary film. Fluorescent lights and low pressure vapor lamps (mercury and sodium) emit a non-continuous spectrum which doesn't match either the eye well, and is hard to correct for film. Pure sky light tends to blue, and needs a slight red (warming) filter to look natural.
<the primary colors of paints are red, blue and yellow>
The following is from the Paintshop Pro help file:
"The CMYK model, a subtractive color model, is based on light being absorbed and reflected by paint and ink. This model is often used when printing. The primary colors, cyan, magenta, and yellow, are mixed to produce the other colors. When all three are combined, they produce black. Because impurities in the ink make it difficult to produce a true black, a fourth color, black (the K), is added when printing."
<Is there a website that shows visual examples of combined colors of light
including complementary colors?>
As Sean indicates you would be well off with a good book that shows spectral diagrams and color examples. Your image editor should allow you to play with a color chooser, and also convert images to negative which will gives you the complementary colors.
<To use filters to their full potential>
Filters absorb light implying subtractive terminology. They can be of any color, not limited to the primary subtractive colors above. The fraction of light absorbed by a filter can be either narrow (a small part of the spectrum) or wide (most of the spectrum). If you stack more than 2 different narrow-pass filters together you will see darkness, since each will absorb most of the light and let nothing through.
A red filter will make both sky and grass dark (on B&W film). An orange filter will make the sky dark, but not the grass. Color negative film has an orange base, so the result has a blue cast color when turned into a postive (converted to the complimentary colours). Filtering is necessary, and can be done digitally, which has an effect equivalent to an optical filter.
<and for photography in general, I need to "get the big picture" about
colors.>
The eye tends to judge colors by comparing them to adjacent areas, while film does not. The eye is also biased by the light source and tends to compensate, while film does not. The eye is more sensitive to certain wavelengths (green and red), and only perceives color when the light source is bright enough (not in darkness at night), while film undegoes color shifts with long exposures (reciprocity failure).
The RGB scheme is used in computer monitors, TV tubes, transparencies, scanning, imaging and digital cameras. The CMY(K) scheme is used in paints, inks, pigments and negative film. Other 3 color schemes include HSL (hue, saturation, luminance) for image editing, YCC for Jpeg compression, and NTSC and PAL for TV transmision. All of these are derivatives of the RGB scheme.