With the G70 getting closer, it is hard to recommend SLi with the 6800GTs. Early rumors suggest that the G70 will perform better than SLi'd GTs. So, barring insane price gouging, the G70 would be the better price/performance choice.
That being said, for the games you're naming you want to play, you will see a good increase across the board with SLi compared to a single GT--
In Far Cry, at 16x12 4x/8x, of the 11 Far Cry benchmark maps, my single GT never scored above 35fps. Lowest score was 23fps. When put in SLi mode, the lowest score rose to 47fps. Overall, Far Cry showed a 53% increase with SLi.
Doom 3 was similar, except that the game is capped at 60fps. Non-SLi, the game will dip into unplayable levels at these settings, but with SLi, it'll be almost pegged at the cap most of the time. Very smooth.
HL2 sees about a 40% increase with SLi across the board. The differences with this one is that the game plays pretty darn well even with 1 GT at the 16x12 4x/8x settings, only sometimes dipping down to the 30s. In SLi, those dips won't happen.
UT2k4 also gets a good 30-40% increase with SLi. But, just like HL2, it plays very well with 1 GT. You'll just never dip into the 30s with SLi. But in such a twitch game, where every frame counts or you're fragged, it might be best to turn off the AA and keep the frames as high as possible.
Using a video card purchase as an "investment" is a pretty silly idea. That's the way of technology. But the way I look at it, I've been using these settings now since February. I got each GT for around $325 back then, so I couldn't pass it up. If the G70 comes out and is much better than SLi'd GTs, I'll consider upgrading. Let's face it, I could sell the GTs for around $600, be able to get a G70 and pocket some cash, or fork over an extra $200 or so for SLI G70s.
I still stand by SLi being a good upgrade path. It's the initial investment that's a killer, but after that, you'll pay near what everyone else is paying to upgrade to the next gen, except you'll get 2 cards. Single-card owners will sell their single card and buy a next gen, probably spending $100 to $200 out of pocket. SLi GT owners can sell off both their cards and either make money getting the next gen, or drop around the same (or a little more) that single card owners will and have dual next gen.