An armed man stormed into a US hospital's intensive care unit and took staff members hostage before he was killed by police in a shootout.