Ya there's too many problems with SLI/CF right now for anyone to recommend one or the other with a clear conscience. I went with an 8800 this round though because it offers SLI/CF-like performance in a single card solution with the possibility to double up later on.
If you're dead set on running SLI/CF at some point and don't know if you want to go with 2x 8800s, you're better off waiting for the R600s as buying 2 X1900s to use in CF doesn't make much sense at this point. On the nVidia side there's tons of driver problems with SLI under both XP (lots of compatibility and performance issues) and Vista (no SLI support at all right now) and it also looks like there's a lot of questions in terms of platform support for CF and SLI. You've got the potential for AMD and Intel drawing party lines in terms of SLI/CF support, making it an ugly situation for the end-user.
If you bought today, a single 8800 GTS or GTX would be the best option without committing too much into SLI or CF.