This is an older motel, but we had a waterfront room and even though it needed some TLC we really enjoyed our visit. One important note though - hotels.com lists it as having a free breakfast and they didn't when we were there (off season, mid-week). There are fast food, sit down, and store options in nearby Ogdensburg. We got take out and brought it back to eat in front of our gorgeous view. We did this for lunch and supper too.
Location next to the river and near Ogdensburg was perfect for our needs and we'd easily stay here again in a waterfront room.