OP, generic store bought pies are *terrible*. I will include specialist/gourmet ones in that list. I have tasted a lot of them from pretty much New York to here, and never liked them.
We take turns hosting Thanksgiving with my cousin. HE loves Pecan Pie. It's his single request for Thanksgiving (and why I have eaten so.damn.many pecan pies). He no longer requests pecan pies, because I make this for him:
https://www.joyofbaking.com/barsandsquares/PecanSquares.html
Do try. It's super easy, and delicious. DO NOT substitute Karo syrup for Lyle's; that's probably what makes the biggest difference in how amazing this tastes.