How to achieve this look/unwrap (Swirl texture on tree)
I think you are almost there, just unwrap with the Follow Active Quads option (select all in Edit mode then reselect one of the faces to make this face active) and rotate the UV map in the UV Editor: