Good question. I'm definitely keen to visit Canberra on a footy related trip in the near future. But I wouldn't be inclined to visit there during the off season. For this Xmas, the fam wanted to hit up the GC theme parks and tbh I wanted to go to Australia Zoo on the Sunshine Coast, but in the end we settles on staying on the GC. I still may hire a car and drive the 2 hours to the SC though. I did consider Brisbane as it's centered between them, and I do have family there...but then I'd have to come on here and admit to Broncos fans that I visited their city and liked it lol.
I don't actually know if I could live in a holiday destination. I live in Christchurch, and it could be similar to Canberra as there's not much to do here as the earthquakes smashed the CBD, and it's cold in the winter (very hot in the summer though). But I'm becoming a homebody in my mid 30's, and I don't really care much about a thriving night life etc. I'm from Wellington, which is also cold but does have a thriving night life, but it also wouldn't be considered a holiday destination. Holidays to tropical places would have much less impact on me if I lived in a city deemed a holiday destination.
