What happens in Canada or the USA if a person with a lot of money dies, but has no will and no heirs at all?

Those distant cousins will come out of the woodwork for their favorite relatives MONEY. Barring that in the US it would go to the state coffers.