Even if you're going with CGI scripts (no mod_perl but dynamic content) it's reasonably easy to have nice-looking urls that don't even show the actually executed script. One commonly used option is to configure a url-to-script mapping using
mod_rewrite.
mod_proxy mod_rewrite should be available and configurable via .htaccess files on most hosts that provide CGI.