If he had the Haldol ordered (depending on what the order stated: ie, prn agitation, etc.), I would have used it. Climbing out of bed at all hours of the night makes him a danger to himself. What if you hadn't caught him doing it those 6 times? Did you have a bed alarm on? Even with a bed alarm, what if you were in a situation that didn't allow you to leave to check on him? If he had fallen, would you be able to explain to his family or the physician why you didn't use a prn medication that could have prevented it?
If the geri chair had the tray down, that would be considered a restraint, and you didn't mention having an order for one prior to the soft restraints. He may have been calm during report because he wore himself out during the night. Would he have had a much more peaceful experience if he would have had the haldol to take the edge off enough to rest throughout the night instead of wearing himself out to the point of exhaustion? Maybe, maybe not.
The point I'm trying to make is that just because you don't believe in "heavily medicating" your elderly patients, doesn't mean that it's not necessary, or in the best interest of the patient and their safety. As far as whether or not it would have made your night "easier" so you didn't have to "run your feet off" isn't what you should be focusing on. Next time, I would suggest taking a step back and asking yourself what the pros and cons are to using the medication. What's the best outcome of giving the haldol (patient is less agitated, not climbing out of bed, and may get some much needed rest), and what's the worst outcome (haldol doesn't effectively calm the patient down)? If it didn't work, then that was something you could have passed on in report, or informed the physician about so that something different could be tried.
If you had used the haldol, you may have kept the patient safe and saved yourself from possibly having to fill out an incident report.
I'm not being judgmental here, as you have your own convictions for not wanting to use it. However, as I said above, maybe taking a step back and weighing the positive and negative outcomes may help you to make a more objective decision in the future.
The confused elderly are a challenge, so I commend you on coming up with a creative solution. Best of luck with this in the future!