What happens when multiple products each have a custom Thank You page assigned?

Answer: The first product in the cart to have a Thank You page will be used for the redirect.