For example: if you look at a red piece of paper in a room that is lit with a regular lightbult. The paper does not create photons so what's happening?

Why the piece of paper appears red is because it is reflecting the "red photons" more than it reflects other photons (which it ends up absorbing). So, it's mostly the red photons that make it to your eyes.