One of the main attractions of Cologne is the Cologne Cathedral, the spires of which you see right above the train station. Even if you don't have much time, you can hop off the train and see the Cathedral on a short stop-over.
The Cathedral is to the south of Cologne's main train station, to the north you'll find quite a few hotels within short walking distance.
