At this point, intel is not a great choice. They fund development of open source drivers for linux, but the code is very linux specific. Their developers regularly break the mesa/libdrm builds for other operating systems and, at this point, newer versions of the 2D driver won't work till the memory manager in the intel DRM is ported over to FreeBSD.
rnoland@ (the FreeBSD ports maintainer) has had more luck with the codebase for the ATI drivers. All r1xx through r7xx cards (up to the HD4950) have 2D and 3D acceleration. The 3D acceleration is brand new and somewhat experimental for r6xx/r7xx cards, and requires building various components from git. r1xx through r5xx is more stable. They are all certainly functional enough to run compiz and play games such as openarena, nexuiz, and neverball. The linux compat layer is missing something, though, so the only way to accelerate 3D linux applications is via indirect rendering. This works for the most part, but is not ideal.
In comparison to the open source drivers on linux, the ones on FreeBSD are missing KMS, DRI2, and gallium3d. rnoland has started on KMS (which should hopefully bring along the latter two) but it's non-trivial work and he hasn't much time to work on it yet. g3d is not really usable, even on linux.
And, yes, once nvidia releases AMD64 drivers for FreeBSD, there is no doubt that they will be faster and more fully featured than the open source drivers for ATI/AMD cards. Supposedly they will also properly support linux applications, too.