Three nights in Cologne felt like a good amount of time to get a feel for the city. I can imagine it's a totally different atmosphere in Spring/Summer when you'd sit outside enjoying a drink, take a walk along the Rhine or maybe enjoy a river cruise (they stop over the winter) I'd definitely go