Rewrite numba.{carray,farray} support using @overload #8009

#7996 highlights that there's likely an issue with numba.{carray,farray}, where the CallableTemplate uses Numba types instead of Python values for the defaults in the typer kwargs. Getting this to work at all with @overload_glue was extremely challenging, as a result, instead of fixing the issue noted by @sklam here #7996 (comment) the time will be spend on translating numba.carray and numba.farray to use @overload as it is known to help prevent such issues and also translating it will improve compilation performance for these functions (fewer wrappers!).