The cable like you pictured is definitely the way to go -- I have both a BNC-SMA adapter, and a cable that has SMA on one end, and the cable with SMA is a lot easier to deal with.
As for the price difference, I cannot explain it. I paid about $12 for mine several years ago.
-Kevin