Definitely.
No matter how super aroused he gets me, and even if we use lube, I'm still going to feel it the next day.
I couldn't walk and had to take a "sick day" off work once, but I think that had more to do with the fact that we stayed in and had sex all day than the size of his penis (although that didn't help things)