Can anyone please explain the differences between these two? If you just want to add a keyword search function to your site, which is better? I don't mind paying money for more features, but I'm not even sure which one is free and which one is not.
Google Site Search will search one site, whereas you Google Custom search can be configured to search multiple sites at once. So SiteSearch is probably the right choice in your case.