I used multiple 'teaser rate' offers to work my way out of many thousands of dollars of debt after my divorce.
It can't hurt to call and ask if the fee can be waived; but since you're a new customer that they've made zero money from, they don't have any reason to do it.
You have to read the fine print, and take steps to ensure you adhere to it.
As far as I know, the balance transfer offers are only for balances on other credit cards.
And some certain credit cards can NOT be transferred to certain other cards. They have to be in different card 'parent' companies (I'm not sure what the correct term for this is).
I always kept a 'regular interest' card open that I could transfer balances to - right before the offer expired.
And at least once, I transferred a balance (or part of) to that card (and paid a fee to do it) so I could then transfer the balance to a new teaser rate card.
Do not close any of the cards you get, unless they charge a fee and won't waive it for you. Use them once a year or so to keep the account in good standing - paying annual association fees (etc.) are great for this.