No, I don't think that a content type will address this. The limitation is in the InfoPath connection wizard. You have to provide a full URL. Notice how there's no option to use a formula, or a field from the form, etc. It's an absolute path URL.
Sorry, I can't think of a workaround or solution.