I'd certainly recommend a couple of full days (but I already lived/worked in St. John's so have an experience advantage!). In addition to the activities you identified, a walk up Signal Hill and visit to Cabot Tower is a must do. Pok8ng around on Water Street is a good way to pass some time. There should not be any icebergs in September, 2024.... that sort of comes to an end in June.