Well, job creation and provincial economic fortunes are impacted by many variables, not just the HST. Job creation is directly tied to GDP growth over the long run. Any economic factors that lowers the cost of sales for a business, makes them more competitive, increases their profits and investment and allows them to invest in growth and hire more workers.
That said, there are outside mitigating factors (such as massive unemployment in the US, global credit market meltdowns etc...) that also have a substantial impact on the GDP of BC and Canada. These outside factors are beyond our control as a province. The HST however is a taxation policy that we can directly control, that lowers the cost of doing business in BC (by eliminating compound taxation of business inputs) and in the long run, has a net positive benefit for the province -- just like over the long term, the GST have provided Canada with a net positive benefit.
It's meaningless to relate short term job growth, or job loss to the HST as there are so many factors that impact whether our economy expands or contracts. As a citizen of the province, I want to see every measure in place to boost our economic fortunes and I am convinced that eliminating our antiquated PST taxation system and replacing it with the HST helps in this regard.
So to answer your question -- as a family man in BC -- you might pay higher taxes under the HST. Will it amount to much -- in some situations yes, in most situations no, and for some people they will pay less. On the average, the hard dollars you pay will be about the same. For the province, it means a more competitive business environment over the long run, which should lead to growth in the number of jobs, an increase in consumption of goods and services and increased taxation revenues to fund healthcare, education, roads, etc.... which you as a family man use today.