Found it, Yoma 75a:
תַּנְיָא, אָמַר רַבִּי יוֹסֵי: בּוֹא וּרְאֵה שֶׁלֹּא כְּמִדַּת
הַקָּדוֹשׁ בָּרוּךְ הוּא מִדַּת בָּשָׂר וָדָם. מִדַּת בָּשָׂר וָדָם:
מַקְנִיט אֶת חֲבֵירוֹ — יוֹרֵד עִמּוֹ לְחַיָּיו. אֲבָל הַקָּדוֹשׁ
בָּרוּךְ הוּא אֵינוֹ כֵּן: קִלֵּל אֶת הַנָּחָשׁ, עוֹלֶה לַגָּג —
מְזוֹנוֹתָיו עִמּוֹ, יוֹרֵד לְמַטָּה — מְזוֹנוֹתָיו עִמּוֹ.
With regard to the same topic, it was taught in a baraita: Rabbi Yosei
said: Come and see that the attribute of the Holy One, Blessed be He,
is different than the attribute of flesh and blood. The attribute of
flesh and blood is that one who seeks to provoke another harasses him
in all aspects of his life, but the Holy One, Blessed be He, does not
act in this way. He cursed the serpent and what happened? When the
serpent goes up to the roof its food is with it, and when it comes
down its food is with it. Consequently, the curse that it suffers does
not ruin its life but rather benefits it.
קִלֵּל אֶת כְּנַעַן, אוֹכֵל מַה שֶּׁרַבּוֹ אוֹכֵל וְשׁוֹתֶה מַה
שֶּׁרַבּוֹ שׁוֹתֶה. קִלֵּל אֶת הָאִשָּׁה — הַכֹּל רָצִין אַחֲרֶיהָ.
קִלֵּל אֶת הָאֲדָמָה — הַכֹּל נִיזּוֹנִין הֵימֶנָּה.
Similarly, He cursed Canaan that he should be the servant of servants,
but he benefits somewhat from this. He eats what his master eats, and
drinks what his master drinks, and does not worry like a free man
does. He cursed the woman and everyone pursues her to marry her. He
cursed the land after the sin of Adam and Eve, yet everyone is
sustained from it. Even when God is angry, He does not punish His
creations severely.
(translation with Steinsaltz comments included)