We solve the problem in two steps.
First we solve the problem of a random walk with no cliff.
Then we show how the solution to the problem with the cliff can be expressed in therms of the solution without the cliff.
Unconstrained walk
Consider the problem of a random walker moving without a cliff, i.e. just an unconstrained random walker.
Denote the probability of arriving at point $j$, having started at point $i$, after $n$ steps, by the symbol $p_{ji}(n)$.
Let $k$ denote the number of rightward steps.
Then the number of leftward steps is $n - k$.
The number of ways we can arrange $k$ rightward and $n - k$ leftward steps is
$$\frac{n!}{k! (n - k)!}$$
and the probability of getting any such string of steps is
$$p^{n - k}q^{k} \, ,$$
so the probability of such a walk is
$$p_{ji}(n) = p^{n - k}q^{k} \frac{n!}{k! (n - k)!} \, . $$
The displacement $d$ of this walk is the distance between the end and start points, $d \equiv j - i$.
This displacement must also be equal to the the number of rightward steps minus the number of leftward steps,
\begin{align}
d &= k - (n - k) \\
\implies k &= (d + n) / 2 \, .
\end{align}
Therefore,
$$p_{ji}(n) = p^{(n - d)/2} q^{(n + d)/2}
\frac{n!}{\Big(\frac{n - d}{2}\Big)! \Big(\frac{n + d}{2}\Big)!} \, . $$
Note that this expression is only valid when $n$ and $d$ are both even or both odd.
Otherwise, $p_{ji}(n)$ is zero.
Note also that the problem has translational symmetry; $i$ and $j$ do not appear in the expression for $p_{ji}(n)$.
The random walk probabilities depend only on the translation, so we replace the $ji$ subscript with $d$, writing
$$p_d(n) = p^{(n - d)/2} q^{(n + d)/2}
\frac{n!}{\Big(\frac{n - d}{2}\Big)! \Big(\frac{n + d}{2}\Big)!} \, . $$
Generating functions
Of course, we need to solve the original problem which includes the cliff.
Let $f_{ji}(n)$ denote the probability that the walker arrives at point $j$ for the first time, having started at point $i$, after $n$ steps.
Again, by translational symmetry we can write this as $f_d(n)$.
The answer to the question "what is the probability that the walker ever falls off the cliff" is
$$\text{Probability of falling} = \sum_{n=0}^\infty f_{-1}(n) \, .$$
Now here's the amazing part: if we define generating functions for $p_d(n)$ and $f_d(n)$ as
$$
P_d(z) \equiv \sum_{n=0}^\infty p_d(n) z^n
\qquad
F_d(z) \equiv \sum_{n=0}^\infty f_d(n) z^n \, ,
$$
then it turns out that $^{[a]}$
$$F_d(z) = P_d(z) / P_0(z) \, .$$
This is awesome because the the probability that the walker ever falls off the cliff is
\begin{align}
\text{Probability of falling}
&=\sum_{n=0}^\infty f_{-1}(n) \\
&= \lim_{z \rightarrow 1} F_{-1}(z) \\
&= \lim_{z \rightarrow 1} P_{-1}(z) / P_0(z) \\
&= \lim_{z \rightarrow 1} \left( \sum_{n=0}^\infty p_{-1}(n)z^n \right) / \left( \sum_{n=0}^\infty p_0(n) z^n \right) \, .
\end{align}
Thus, we've written the solution to the problem purely in terms of the unconstrained probabilities for which we already found a solution!
All that remains is doing the sums.
Solution
It turns out that
$$P_{-1}(z) = \sum_{n=0}^\infty p_{-1}(n)z^n = \frac{1}{2qz} \frac{1 - \sqrt{1 - 4 pqz^2}}{\sqrt{1 - 4pqz^2}}$$
and
$$P_0(z) = \sum_{n=0}^\infty p_0(n)z^n = \frac{1}{\sqrt{1 - 4pqz^2}}$$
so
\begin{align}
\text{Probability of falling}
&= \lim_{z \rightarrow 1} P_{-1}(z) / P_0(z) \\
&= \lim_{z \rightarrow 1} \frac{1 - \sqrt{1 - 4pqz^2}}{2qz} \\
&= \lim_{z \rightarrow 1} \frac{1 - \sqrt{1 - 4p(1-p)z^2}}{2(1-p)z} \\
&= \frac{1 - 2\sqrt{(p - 1/2)^2}}{2(1-p)} \\
&= \left\{ \begin{array}{ll} \frac{p}{1-p} & p < 1/2 \\ 1 & p > 1/2 \end{array} \right.
\end{align}
which solves the problem.
It's pretty cool that this method got the kink at $p=1/2$ without us having to make any extra logical arguments.
$\lim_{z \rightarrow 1}$
It's interesting to think about the meaning of the limit $z \rightarrow 1$.
The sums over $n$ in the generating functions involve the factor $z^n$.
For $|z|<1$, the sums de-emphasize terms with large numbers of steps.
In other words, $z<1$ means that we don't count long walks as much when computing the probability of falling off the cliff.
In Figure 1 we plot the probability of falling off the cliff for various values of $z$.
For low values of $z$ the probability of falling off the cliff is low for all $p$.
This makes sense because low $z$ means that we strongly de-emphasize longer walks; even with $p=1$ we may not fall off the cliff because $z<1$ means we don't always even count the first step.
For higher values of $z$ the probability to fall off increases.
At $z=1$, which represents the original problem, the curve forms a cusp at $p=1/2$.
It is interesting that the sequence of curves for values of $z$ less than one has no cusp, yet the limiting curve for $z=1$ does have a cusp.
For $z>1$ the curve diverges.
Figure 1: Absorption probability as a function of $p$ for a few values of $z$.
Higher moments
Note that if we want to compute higher moments of the number of steps of the random walk we can do it by differentiating the expression we already found.
For example, the mean number of steps before falling off the cliff is
\begin{align}
\sum_{n=0}^\infty f_{-1}(n) n
&= \lim_{z \rightarrow 1} \frac{d}{dz} \sum_{n=0}^\infty f_{-1}(n) z^n \\
&= \lim_{z \rightarrow 1} \frac{d}{dz} F_{-1}(z) \\
&= \frac{p}{\sqrt{(p - 1/2)^2}} - \frac{1 - 2\sqrt{(p - 1/2)^2}}{2(1 - p)} \\
&= \left\{ \begin{array}{ll}
\frac{p}{p-1/2} - 1 & p > 1/2 \\
\frac{p}{1/2 - p} - \frac{p}{1 - p} & p < 1/2 \, .
\end{array} \right.
\end{align}
Note that this function goes to $1$ as $p \rightarrow 1$, which makes sense because the walker has to fall off on the first step.
The other asymptotic behaviors look wrong though, so maybe I messed up some algebra.
$[a]$: You can prove this by thinking of every walk as two parts: a first part which gets to $j$ for the first time, and then a second part which wanders off but eventually ends up at $j$.