Should I spray texture on my drywall repair?
If the current walls are textured with an orange peel texture, then, yes, go ahead and use the 'texture in a can' to replicate. 

Every wall in our house is orange peel (blech) so when I created an interior bump out with new sheetrock, I caved in and sprayed to match. I was pleasantly surprised to find the texture-in-a-can is rather easy to apply and seems to do the job just fine.