Hard to predict. If you’re good at adjusting to different circumstances, and find that sort of change stimulates your creativity, it could work out.
I’ve done some retreat/residency/fellowship things. One was in Alaska, where I had a house on a steep seacoast for a month, with a stipend. Had to do the cooking and housekeeping myself, and got flown out to bush schools to rev up the kiddies, and did a couple public events. But otherwise, my time was my own and no one interrupted me. I used the time to complete the final revisions on a poetry manuscript before publication. It was a wonderful time.
Also did a master class at an arts centre, two weeks, a small workshop with a fiction writer I admire to the stars. There were parallel retreats with painters and composers, so it was fun to hang out in the evenings and drink wine and converse. Meals were provided, with hotel-style service, so all I had to do was attend the daily workshop, go on field trips, and write. The leader liked my first shot at fiction and gave me good tips on revision. The result was getting my short story published.
A self-funded, self-managed retreat can be really good if you know what you need, whether urban buzz or the piney woods. Having to do the cooking and housekeeping might put you back in the daily grind you’re trying to escape, in an unfamiliar place. So getting food and housekeeping service might be a good break, even though it costs more.
I also spent a couple weeks in cheap hotels and beach shacks in Mexico, riding buses, eating street food. It wasn’t always comfy, but it was good for writing.