Putty is nice and unobtrusive when you have a working serial connection that you want to use. Some of the other programs are helpful when troubleshooting or debugging serial connections. I've used RealTerm in the past, but I found it quite cumbersome for basic serial console work for some reason, don't remember the exact issues, may have been related to escape or control characters.