Is an offset account worth it?
One line of arithmetic answers this. Multiply the balance you typically keep by your interest rate. That is roughly what the offset saves you in a year. Then compare it to the annual package fee.
Commonwealth Bank's Home Loan Wealth Package, for example, carries a non-refundable annual fee of $395 payable in advance.4 At a 6% interest rate, you would need to hold roughly $6,600 on average for the offset to cover that fee alone. Below that, the package is costing you money for the privilege of saving less than it charges.
Where it is clearly worth it
If you hold a genuine emergency fund, run your salary through the account, or are saving toward something a year or two out, the balance is real and the offset earns its keep comfortably. If your account balance is near zero the day before each payday, it almost certainly does not.
Worth checking either way: the fee is a certainty and the saving is not. If you are reviewing this, it is worth reviewing the rest of the loan at the same time, because a package fee attached to an uncompetitive rate is two problems, not one.