To address your original question and add a few comments:
No, a circulating fan inside your closed cabinet and occasionally opening the door won't be enough. Even if the overall temperature were still in an acceptable range for growing (which is doubtful), without external air being vented inside, your plants would be starved of C02 and wouldn't grow well. Increased humidity inside a non-vented cab can also promote mold and bud rot. You will need to vent fresh air in, and stale air out.
On venting, IMO, you want to vent air out from the TOP of the cabinet, since hot air rises, and that's where the hottest and most humid air will be inside your cabinet. So you want your fan on TOP of the cabinet, blowing air OUT. Conversely, you want the fresh air coming in from the bottom of the cabinet, since that's where the coolest air is.
To reduce light exposure and visibility, I think having the vent holes on the back of the cab is a good idea.
Depending on the size of the cabinet, how hot it gets, how powerful your fan is, and its internal complexity, you may be able to get away with just one fan on top and just a hole on the bottom for air to come in ("passive intake").
Obviously, you want the cab to be light tight. Nothing gives away a "stealth" cabinet as much as bright light leaking from the seams!
There are multiple ways to go about this, but they all come down to making sure the cracks around the doors are sealed off, and that there isn't a direct path from the lights to the ventilation entrance/exit holes. One way to accomplish the latter is by using pieces of ducting bent at 90 degrees, with the insides painted black for your air intake/exit. Other forms of baffling are possible, and they don't necessarily have to be complex. For example, you could put a box with a hole in the bottom over the bottom vent hole. The box top prevents light from getting out, and the open bottom lets air in, etc.
In terms of what's going to be your best yield, cabinet growing is its own "thing". Rather than try to generalize what "might" happen, realistically it will probably take a trial and error using your particular light setup and strains to figure out what works best for you.
One of the most important things in growing inside of small closed spaces is controlling height. If you're running short compact strains and/or have a good amount of overhead space then this may not be as much of an issue, but if you want to run a stretchy sativa, then you'll need to one or more than one of the various training techniques to reduce overall plant height. I'd assume coming into this that you will probably want to top your plants and/or tie the tops down or otherwise train them to maximize yield.
For short non-branchy strains (only), if you have access to lots of clones, and if you don't mind potting and maintaining a large number of them (including possible increased legal exposure from numbers), then you can have excellent results with a "sea of green" type setup.
SCROG will get you most of the way there with fewer plants, but it takes longer to get the plants trained through the screen. Increased work in doing the training is partly offset by decreased number of plants you have to maintain.