The only Acuras currently in production with a 6-speed are the RSX Type-S 6-speed (2002, and 2003 models), and the CL Type-S 6-speed (2003 model only), both are coupes, but I'm not sure how many you're going to find off the lease ... Other than that, there's the Integra which you might be able to find. The RSX and Integra are both 4-cylinders though, so your only other choice is the CL Type-S 6-speed, a very nice car imho, but its new for 2003 and you probably won't find many off the lease. If you're lucky you might find one used ... But from what I understand the CL-S 6-speed is not in heavy production like its automatic sibling so you'd most likely have to go brand new to find one (and wait a few months) ... So you probably wouldn't save anything by going the CL Type-S route ...
You're probably better off going with the Accord v6 coupe, or considering getting another car off the lease. Perhaps a Nissan Maxima v6 6-speed?