If you want a view of the city, the right-hand / starboard side of the plane is best and then you just have to hope they are landing to the west on the 25s.
Landing from the other direction there is not a whole lot to see. Mainz / Wiesbaden to the left but visually a bit meh.