You shouldn't pay too much attention to the hate, what you find interesting is intensely personal and few others will ever understand. Foundations is in a much better spot than it was 50 years ago, and you can definitely succeed in it.
Having said that, as someone outside the field who peeks in every once and a while, it does seem like a lot of foundations research (that gets noticed at least) is about constructing flashy abstracts out of simple linear algebra. The interesting stuff always seems to belong to another field, like computation, error correction, encryption, etc. Combine this with many physicists' distaste for philosophy, and you'll get the current attitude towards foundations.
Having said that, as someone outside the field who peeks in every once and a while, it does seem like a lot of foundations research (that gets noticed at least) is about constructing flashy abstracts out of simple linear algebra. The interesting stuff always seems to belong to another field, like computation, error correction, encryption, etc. Combine this with many physicists' distaste for philosophy, and you'll get the current attitude towards foundations.