What matters is how many standard deviations apart the means are. See what happens if you take two samples and either
i) add 1000 to both
ii) multiply both by 100
Notice that the t-statistic is unchanged in either case.
However, if you add 10 to one variable, that could change things substantively, if 10 wasn't a small fraction of the standard deviation of the difference in means.
Here's a t-test for two samples (equal variance assumption):
> t.test(x,y,var.equal=TRUE)
Two Sample t-test
data: x and y
t = -4.2271, df = 25, p-value = 0.000276
Note that $t = -4.2271$ and p-value $= 0.000276$
> t.test(x+1000,y+1000,var.equal=TRUE)
Two Sample t-test
data: x + 1000 and y + 1000
t = -4.2271, df = 25, p-value = 0.000276
Adding 1000 to each still gave $t = -4.2271$ and p-value $= 0.000276$
> t.test(x*100,y*100,var.equal=TRUE)
Two Sample t-test
data: x * 100 and y * 100
t = -4.2271, df = 25, p-value = 0.000276
Multiplying each by 100 still gave $t = -4.2271$ and p-value $= 0.000276$. But now see what adding 10 to one of them does:
> t.test(x,y+10,var.equal=TRUE)
Two Sample t-test
data: x and y + 10
t = -30.2065, df = 25, p-value < 2.2e-16
Completely different!
And similarly, assuming normal variability for the two variables, does effect size depend on the absolute values, or does only the relative difference between the two variables (which can be the same regardless whether the variables contain small or large numbers) matter?
That depends on how you defined "effect size". Some people would define it in the original units, others in terms of number of standard deviations or standard errors. In the physical sciences, the first makes more sense, in areas where the raw units don't mean much, the second makes more sense.