Solution was to use matchers to get it to apply to a single host. Also, use the ID instead of the param name.
Example:
hammer sc-param add-override-value --match fqdn=foo.bar.org --puppet-class-id 1245 --smart-class-parameter-id 3800 --value java-1.8.0-oracle-devel
Thanks anyway folks!