Are there any dog sedatives people recommend for a long car ride or a loud celebration (4th of July) to help calm my dog down?

Yes, there are many available, you just need to talk to a vet.

I know of nothing you can get over the counter for this.