There are two constructions which deserve to be called product of functors:
The first is the morphism part of the product functor $\times: \mathcal{Cat} \to \mathcal{Cat}$, sending a pair $F: A \to A'$ and $G:B \to B'$ to the product functor $F \times_1 G: A \times B \to A' \times B'$.
The second is the product in the functor category $[A,B]$, sending a pair $F,G \in [A,B] $ to the categorical product $F \times_2 G \in [A,B]$. It can be calculated in terms of $ \times_1$ as $F \times_2 G = A \xrightarrow{\Delta} A \times A \xrightarrow{F \times_1 G} B \times B \xrightarrow{\times} B $, where $\Delta$ is the diagonal functor.
If we now have functors $F: A \to C$ and $G: B \to C$, which agree on the codomain, but not necessarily the domain, it is natural to consider an in between form of these two products, namely the composite $ A \times B \xrightarrow{F \times_1 G} C \times C \xrightarrow{\times} C$, denoted in the following by $F \times_3 G$.
It seems like $\times_3$ has some nice properties, for example I believe it preserves colimits in the sense $\operatorname{colim} (F \times_3 G) \cong \operatorname{colim} F \times \operatorname{colim} G$ and, in the case $C = \mathrel{\mathcal{Set}} $, it preserves the category of elements construction, i.e. $\int (F \times_3 G) \cong \int F \times \int G$.
Is there a name for $\times_3$? What is it categorically speaking? The product in the slice category $\mathcal{Cat} \downarrow C$?

Your intuition is correct that one should look at the slice category $\mathbf{Cat}/C$. However, your $\times_3$ does not denote the cartesian product in that category (since the cartesian product in a slice category is a pullback). Instead, this is an example of a different monoidal structure on the slice category, which recently came up in another question. In your example $(\mathbf{Cat}, \times, 1)$ is a monoidal category, and $(C, \times, 1)$, is a cartesian monoidal category, hence a monoid in this monoidal category. Consequently, the slice category $\mathbf{Cat}/C$ inherits a pointwise monoidal structure. I'm not aware of a standard name for this structure, but the "pointwise cartesian product" is one possibility.
(Technically, $(C, \times, 1)$ may only be a pseudomonoid, but every category with finite products is equivalent to a category with strict finite products, so we can safely ignore this distinction here.)