I currently use Perforce locally on my computer at home and on my computer at work, and I am very happy with it. But I want to share the SCM Love with my co-workers, and we are about to (maybe) add a third developer. With the inclusion of a third person, we can't continue to use the free version of Perforce. I am not adverse to paying, but $900 a seat is too steep for the company I am working at.
Now, I know there is a strong following for SVN here on StackOverflow, and I respect that. But when I looked into it previously, I did not care for certain aspects. For instance in Perforce, if I try to check in a file that needs to be synched or merged, it will prompt me to do so before checking in, and I get a visual tool to control the merging. IIRC, in SVN, when you check in files it will automatically merge for you which may not have quite the same consequences that you are expecting. I freely admit I may be remembering this incorrectly, though.
Also, I seem to recall that SVN is folder-based and not file-based? This could be really scary in my current work environment where I have inherited some apps with no folder structure.
And, of course, it absolutely has to plugin to Visual Studio 2008.
Given those requirements, would you still recommend SVN or would you recommend another product?