Actually with WebSite Payments Pro you can interface directly with PayPal from your web site by passing all of the information from your site via SSL to PayPal and then interpret the response codes.

Works exactly as any other merchant account does - you take the info, pass it to the process, interpret the code. The user never leaves your web site.

Of course, there are monthly fees with it ($20US) as with any other merchant account.