If you are redirecting to a Common Thank-you Page URL, that would override any other thank-you pages and redirect all buyers to that same URL after checkout. This is the only way to prevent buyers from being able to claim a download immediately following checkout without waiting to receive an email providing a link to their download page. You may wish to update this page with multiple languages and "If you have purchased a file download" instructions.
However, if you remove the Common Thank-you Page URL, it would be possible to redirect buyers to different thank-you page URLs for specific non-download products. This would use the product's Redirection setting, which is normally used to grant access to premium content after payment (e.g., a members-only page or pay-per-view embedded video), so it's considered a form of "digital delivery". This uses our download-link functionality adjusted to redirect instead of start a download, so it can't be used for any product that is already using that functionality to provide a file download. IF the buyer purchases a Redirection product, and IF that is the only item in their order, and IF you have not added custom HTML to your E-junkie-generated thank-you pages, and IF the payment processor completes their payment by the time they proceed past the end of checkout, they would be automatically redirected to the product's Redirection URL; otherwise, they would only access the Redirection URL via a link (similar to our download links) once their payment is completed.