My concern with consolidating credit card and student loan debt into a HELOC would be transferring unsecured debt to debt secured by your home where, if something were to happen to force you to default, you're house would be up for grabs.
If you can do the 0% balance transfers - that's a lower interest rate and does not put your house at risk so I'd go that route and just pay it off as quickly as possible. But then, if you can pay it off quickly anyways - the interest rate is probably not that big of a deal in the first place...