One time a clerk asked why I was buying so much shaving cream at once and I told her it was part of my formula for disposing bodies. Then we laughed. Then we laughed REAL hard. Then it got real quiet. It wasn't until I was just leaving that I noticed that my boner had ripped through my pants.
I only buy 10-15 cans of shaving cream at a time since I have no other use for it except wam. In my experience cashiers don't care because most of them don't want to be there (I worked in retail, companies treat you like shit). If you want to avoid questions go at a time when the store is really busy and they just want to get you through the line as fast as possible.
The only time I had someone question a purchase was when I went out in the middle of a blizzard to get the makings for 20 pudding pies topped with cool whip. I was the only person in the store and I think the cashier was just bored and trying to make conversation, she asked if I baked a lot and all I could think to say was, "oh...this isn't for me..." after that she didn't look me in the eye but honestly I don't care what some random person thinks I'm doing with anything I buy. It's not like I'm making meth, I'm just being a pervert which is totally legal.
Agree with everyone above, 90% of the time they don't say a word, just want to get you scanned through and out, another customer closer to their next break or end of shift. If someone does ask something, just say "just stocking up", or "I always run out, figure if I buy loads it'll do me for a while" or something like that.
Also bear in mind that the more money a store makes the more secure the employees' jobs are. So anyone who comes in and spends money is good news to them.