He's one of the slamdunk first 4 picks in either format, PPR or standard. The others of course being Peterson, MJD, and Forte. Only difference being how much stock you put in the reception totals. Turner and AP are virtually non-existent in their team's passing games, whereas MJD and Forte will likely post somewhere around 55-60 catches to go along with their rushing totals.
I've always felt curses were for backwoods Louisiana witch doctors and Cubs fans. Larry Johnson is a popular example of the "370" stigma, when the fact of the matter is that his offensive line started retiring or getting injured the year after he posted that total. L.T. was just fine after he had that type of year. Turner was a backup who barely saw the field in San Diego aside from mopup time when SD was running out the clock in the 4th quarter so he's got plenty of tread left.
Even if you project a 20% decline in his across-the-board production from last year, that still leaves him in the top 4, and in consideration for the #1 pick overall in non-PPR leagues. He and DeAngelo Williams both outscored Peterson last year by a comfortable margin due to TD totals.
So yes, if by some chance he's there at 4 in your draft, feel very safe picking him and be glad he fell to you.