I've heard lots of transfer stories on this board (mostly good and a few bad), but I have to tell you that my transfer was a truly beautiful experience. Part of that MAY have been that I took a valium 30 minutes prior to the procedure (not to relax me, they said, but to relax my uterus), so I was feeling pretty happy and calm.
The embryologist let us look at our embies under the microscope before starting, which, for a molecular biologist like myself, was awesome, and she also gave us a few pictures of the two blasts to keep. The procedure itself was simple - I felt no discomfort at all and as we watched on the monitor, we imagined that we could see our embies moving down the catheter line. We couldn't, of course, all we could really see was the fluid and the air bubbles, but it was neat to imagine it. The actual transfer didn't take more than a couple minutes, but they had me remain lying down on the table for 30 additional minutes. It was a really special time for me and DH to talk and laugh and be more hopeful than we'd been in many years...
Even though we've hit a lot of bumps in the road since then, I'll always have very fond memories of my first transfer. If we ever have to do it again, I hope to experience the same thing!