The problem with attempting to do the analysis with the forward point of contact on the box when it is sliding is that the box is accelerating. This makes a non-inertial frame and there's more moving parts. Besides the force of gravity on the center of mass, there will be fictitious forces.
First, lets assume friction is zero. If so, we can calculate the acceleration of the box.
$$F_{x'} = mg\sin \theta$$
$$a_{x'} = g\sin \theta$$
In an accelerating frame, we get fictitious forces.
$$ F_{fict} = -ma_{frame}$$
$$ F_{fict} = -mg\sin \theta$$
The sign indicates the force is opposite the direction of the acceleration. The case where we expect the box to tip most likely is where it is tall and not wide. Let's assume the width is minimal (a rod sliding on its end). If so, the torque from gravity will be the COM at half the height, and leaning forward $\sin \theta$
$$\tau_g = \frac12 hmg \sin \theta$$
Meanwhile the fictitious force is located at half the height and points opposite the acceleration vector, so it has a lever arm of exactly half the height.
$$\tau_{fict} = F_{fict} d$$
$$\tau_{fict} = -\frac12 hmg\sin \theta$$
$$ \tau_{net} = \tau_{g} + \tau_{fict}$$
$$ \tau_{net} = \frac12 hmg \sin \theta - \frac12hmg \sin \theta$$
$$ \tau_{net} = 0$$
If you add friction, you will reduce the acceleration of the box, reducing the fictitious force in this frame. When that happens, the net torque would be sufficient to tip a rod, but would depend on the dimensions if a box would tip over.
I didn't do the math, but $\tau_{fict}$ should be pretty simple to calculate, and then $\tau_{g}$ becomes $\frac12h\sin \theta - \frac12w\cos \theta$ (I think)...
Sorry, I wanted to reply to this comment, and I couldn't do it in the comment space.
If we instead take the static plane to be the frame of reference (and
a minimal width box), wouldn't we get the same results anyways?
The problem is that in the frame of the plane, the axis you want to consider in the question (the front corner of the box) is accelerating. I don't think that's okay to do. Let's imagine a pendulum being accelerated via a force on the axis. And we let it reach steady state so the angle isn't changing.
The solid pendulum has a force accelerating it to the right, and it has gravity pulling it down. The force is applied directly at the axis and contributes no torque. Gravity pulls the weight down, so is applying a torque of $(mg \times L\sin \theta)$. Yet the pendulum does not rotate. Perhaps someone else has more information about this situation. My intuition is that this is simply the wrong technique for an accelerating axis, but I'm not sure what the correct analysis would be.
First lets give the box some dimensions: $w$ for width and $h$ for height.
A level, stationary box
The scenario you described above is almost correct if $F\,h\leq m\,g\,w$.
The net torque on the box would be $F\frac{h}2 - N\frac{w}2$, which if $N=m\,g$ would result in a net counter clockwise (negative in my chosen reference frame) torque. This would mean the corner not in red would be pushed into the floor, supporting some of the weight of the box, reducing $N$ until $F\frac{h}2 - N\frac{w}2 = 0$.
An accelerating box
If there is a net torque on the box (i.e. $F\frac{h}2 - N\frac{w}2 \geq 0$) then the box will be accelerating around the red corner. Note that to accelerate around the red corner would accelerate the center of mass. Since it's accelerating we can no longer claim that the net forces are zero. In particular now $F\gt F_\text{friction}$ and $N\gt m\,g$.
So Your first and second questions are answered by the fact that yes $N$ will increase as the box starts rotating, but that increase will allow it to overpower the weight of the box allowing the center of mass to accelerate upwards. Once the center of mass has moved upwards, there is now room for the corner to rotate without penetrating the ground.
As for your third question. No $F\neq F_\text{friction}$ once the box starts accelerating. $F_\text{friction}$ will reduce once the box starts rotating.
For your forth question, the net linear acceleration of the CG is not zero. You are correct that the CG describes an arc of a circle.
If you would like to calculate these values I would proceed as follows:
The moment of inertia of a box about its corner is
$$I=m\frac{w^2+h^2}3 \, .$$
The angular equivalent of $F=ma$ is
$$\tau=I\,\alpha=I\,\dot\omega=I\,\ddot\theta \, .$$
Now before we looked at the net torque about the center of gravity. While it's possible to solve this problem using that origin, choosing the red dot as our center allows us to skip a few steps:
\begin{align}
\tau &= F\frac{h\,\cos(\theta)+w\,\sin(\theta)}2-m\,g\frac{w\,\cos(\theta)-h\,\sin(\theta)}2 \\
\ddot\theta &= F\frac{h\,\cos(\theta)+w\,\sin(\theta)}{2I}-m\,g\frac{w\,\cos(\theta)-h\,\sin(\theta)}{2I} \, .
\end{align}
Unfortunately, this is equivalent to the large oscillation pendulum problem by a rotation of coordinate system. As such there is no analytic solution, but a numerical solution could get you $\theta(t)$.
Of course this solution would only be valid up to the point where friction would give way $F_\text{friction}>\mu_\text{static}N$.
Best Answer
Simplifying the problem slightly, I think it can be solved. Assumptions:
Now we can draw a picture of the box at some point:
It is easy to see that $$d = \frac{w}{2} \sin \theta\\ \Gamma = F_{friction} d$$
Now your question was - "what is the force of friction, and how do I deal with the fact that the apparent origin of rotation may not be the center of the box?" That deserves some more thought.
You are right that the force of friction is in the opposite direction of the motion at every point. Thus, when you describe the motion of the box as the sum of a translation and a rotation (at a given instant in time), the net force of friction can be computed as the sum of a torque (due to rotation of the box) and a linear force through the center of the box (since for translation all points in the box move at the same speed in the same direction).
This should make the problem more tractable in terms of the equations of motion - at every moment in time, you can write down the total torque on the box as the sum of the applied torque (from the pair of forces shown in my picture) minus the frictional torque (due to the rotation of the box) plus the net force on the box (after taking account of the torque) accelerating the center of mass. I will see if I have time later to write down the equations more fully.