Can I turn off the new ticket email notification for requester based on the ticket's properties?

You can do this by creating a workflow automator from Admin-->Workflow Automator-->New ticket automator. Set the event as “Ticket is created”. Drag and drop a condition block into the workflow and provide the condition as per the ticket property that you would like to check. Now add an action block and choose the action as “Skip New ticket email notifications”