The Metropolitan Police force has apologised over its investigation into the death of an American drag artist in April 2023.