I personally find the game's aimbot more annoying than helpful, both in PvE and PvP. Nothing is more frustrating than having the perfect shot(s) lined up and having a mob or enemy Guardian cross in front of your sights and have the aimbot pull your aim to the left or right because it's trying to aim for you.
I personally think this feature should be optional.
[spoiler]And let's be honest here, if there were a PC version of Destiny, it would be optional. No need for an aimbot with a mouse.[/spoiler]