Hotels with a view in Germany

We have checked one view in Cologne: Cologne Cathedral. Each page names the hotels that sell rooms with the view, the exact room category to book, and the look-alike rooms to skip.