My wife and I are so happy to be able to say that we stayed in a tugboat for a night. It was such a cute and unique experience. The boat was easy to find, well maintained and decorated, and very clean. Of course there wasn't a tremendous amount of space as it was a tug boat, but I thought the layout and designed really made the most of the space in some very clever ways, and it managed to never feel cramped. The one exception was the bathroom, which was a tight fit indeed, but again, it's a tugboat, so I would not have expected a full walk in bathroom and it's not something I would count as a knock against the experience. In fact, Daniel provided incredibly well written and humorous instructions on how to use the bathroom, as well as directions to the nearby full bathrooms and showers to be found a short walk back on terra firma.
It was really nice being rocked to sleep by the waves. We took Dramamine that night so motion sickness never became an issue for us, but if you are prone to sea sickness...well, it is a boat and it still rocks a bit even if it's tied to a pier. But for us it was an absolute plus, and the back of the boat had two deck chairs and a table with an umbrella, and it was really nice to sit out there and watch the sun set over the water.
There is a parking garage and several bars/restaurants as soon as you walk off of the pier, so a person/couple could easily spend a weekend just hanging out without needing to go far, though there is so much to do in Providence that I would recommend venturing out.
There was virtually no noise at night and we felt totally safe. We had a contactless check in so I never met Daniel in person, but since there were no issues at all during our stay, I never had a reason to contact him. He gave very clear instructions, both through airbnb and in an in-boat guide, on how to work everything and what was nearby.
This was a very pleasant experience and we would definitely stay here again!