I don't really have an answer to most of your questions, but I think I can tell you why some people prefer a standard transmission to automatic.
A lot of people prefer to have the extra control that a manual transmission brings. It's more fun, unless you happen to be driving to work during rush hour...then it sucks.
A lot of auto transmissions are sloppy and tend to shift (or not shift) at the most inopportune of times.
There's a reason why most high end sports cars have standard transmissions. That said, BMW's SMG II is unbelievably slick. It's kinda like what they use in F1 cars (I think WRC rally cars use something similar too).
Still, auto or manual, there's nothing' wrong with owning a 240SX! How many other sporty, affordable FR cars do you know of?