Sandy was the same, she'd have a crazy hour every night and nothing we did seemed to satisfy her. So I resorted to taking her out for a walk when the crazies started. This worked most of the time, but occasionally the crazies would return the minute we got back in the house
She is 5 months now and the crazies seem to visit less often. When they do make an appearance she gets a frozen raw chicken wing which tends to pacify her.
You are not alone, it is a phase most pups go through and they do grow out of it. It is possible its related to being tired, or maybe they are getting rid of all their energy in prep for a long quiet night. Whatever the reason, I agree it can drive a woman mad! Hang on in there and keep trying different techniques, if you are lucky one of them will work