The Moxy at Finkenwerder opened in September 2025. I booked there for location as I was doing an Airbus tour and did not even think about the "airport view".
Rooms 101-127 all have partial runway views Hotel has parking €20 but local streets are free.
On checking in I was allocated a room by chance on the 3rd floor with what turned out to be an airport view from room 317.
Based on the map rooms 307, 309, 311 , 313 315, 319 , 321 or 323 would look to have similar views.
Note 317 was a "Queen Sleeper" room. But the windows by the lift give a view of Hangar 7 and Leak test.
The photo below shows the view from room 205, being a Queen Room with a single bed. From here, you can see aircraft parked in front of the Engine Run Bay and, anything using or crossing the runway.
.JPG)