We're definitely a better sunrise state than sunset! They're harder to catch, but it's worth waking up for. Most places on the south coast or Narragansett will give you a good view over the water. Fisherman's Memorial in Point Judith is the first specific place that comes to mind for me.