Plans to build First Nations cultural centres in Brisbane and Cairns worth more than $300m have been scrapped by the state government, ending decades of lobbying.