Not really. Destiny has a smaller audience than CoD, and Activision Blizzard is a huge purchase with lots a of valuable IPs that go beyond CoD and can still grow (Bungie, OTOH, currently only has Destiny in it's catalog).
Bungie revenue was estimated around $300 million for 2019 vs. $6,5b for Activision Blizzard, so price seems to be in line for both purchases, around 8x annual rev.
Keep in mind Microsoft has bought ton of small studios as well! (Rare, Playground).
Returnal is a good title, but far from being a success by AAA standards (last time they reported sales of the game, in June 2021. it was 560.000 copies). I think part of the aura of success comes from being one of the very few exclusive titles created specifically for the PS5.