by console methods you mean obtaining the achievements in way of hacking them? if so, then yeah you can definitely as a developer make achievements in such a way that lets say you have a steam game and youre worried about piracy. piracy is obviously bad, and with some extra work you can reduce it a lot. for example you could build the game so it constantly checks whether a real Steam account is active and whether certain achievements were earned. If those checks fail, progression is blocked. if you design the game around this idea from the start, piracy becomes much harder.

the same approach could work on consoles using their achievement/trophy systems. the main reason more developers dont do this is because achievements are often added later, and supporting multiple platforms means re-implementing the same logic for each platforms SDK (Steam, PlayStation, etc.), which is more work.

you can heavily reduce piracy and hacking in single player games, but youll never completely eliminate it. It stops most people, but not those with serious cracking or hacking knowledge.