I think they are both a bit overhyped, but I think Destiny will do better, mostly because it is launching on more than double the install base of Titanfall
There are still questions of how Destiny will actually be structured, I just don't understand how it is going to work.
Titanfall is more straightforward, even if it does have some sort of pseudo-single player mode, it is mostly just a multiplayer game