Though part of the Apamea Cham Hotel, it is located on the other side of the road, with spectacular views of four of the noria water wheels which moan as they turn, and its independent access means that most diners at night come from outside the hotel.
The menu is varied (the only non-expensive place in Syria where I found fish available) and prices are very reasonable for excellent cooking. Beer and spirits are served. The only downside is that you are sitting on one of the key sites of the dramatic suppression of the 1982 Hama uprising.
To the north of the centre of Hama, on the east side of the Orontes river and adjacent to Apamea Cham Hotel. Open for dinner, but not necessarily for lunch.