Are there any drugs that will render a man infertile and completely kill his sex drive?

You are asking about "chemical castration". If you narrow your search for that you will find detailed advice. Be aware that many of the suggestions you read will involve the stopping of testosterone production and/or absorption. There are side effects which include feminizing your body, losing muscle tone, hot flashes (from andropause) and others. You should also know that some effects are reversible when you stop taking the medications, but some may become permanent over extended use. Be careful what you wish for. You may get it.