Have you looked at places that are closer to Cologne?

There is no reason you can't take a train from Frankfurt, but I'm sure there must be places nearer to Cologne where you could stay, and cut down on both travel costs and travel times.