There are no loco-hauled, regular passenger diesel trains around Cologne (or anywhere in NRW for that matter). Cologne sees some DMU work, on the line Bedburg(Erft) (RB38, Talent DMUs), to Lüdenscheid (RB25, LINT) and towards Euskirchen (RE12, RE22, RB24, LINT).
The most intresting stuff in regular service is 110 469 on RB48 (Wuppertal stopper) duties (which can be replaced with Talent 2 EMUs at any moment) to the following diagram, MFO:
RB 32508 06:08 Bonn Hbf(Bn) - Wuppertal-Oberbarmen(W-Ob)
RB 32423 08:13 W-Ob - Köln Hbf(K)
RB 32428 09:52 K - W-Ob
RB 32441 11:13 W-Ob - K
RB 32446 12:52 K - W-Ob
RB 32457 14:13 W-Ob - K
RB 32458 15:52 K - W-Ob
RB 32519 17:13 W-Ob - Bn