We stayed here for the Newport Seafood and Wine festival which was about 0.5 miles away. We picked it primarily for the location - it's on the south side of the Yaquina Bay Bridge - by the aquarium and two of the Rogue Newport locations (House of Spirits and Brewer's on the Bay). It is though on the opposite side of the bridge from most of the shops and restaurants in the Yaquina Bay area.
Internet is free but not fast. The rooms are clean and as expected for the Holiday Inn Brand. Breakfast was ok.
Depending on reason for visiting Newport, the Holiday Inn may be a great location.