In America, the 200SX is a front-wheel-drive, two-door Sentra, produced between 1995 and 1998. It was also in production from 1991 to 1994, but it was known as the Sentra coupe, not the 200SX. It came with a 110-hp motor, or in SE-R trim, a 140-hp motor called the SR20DE. The 240SX, on the other hand, is rear-wheel-drive, and comes with a 155-hp motor called the KA24DE. It was produced from 1989 to 1994 (S13) and from 1995 to 1998 (S14). Don't worry about the Japanese models and engines yet.
Will a CRX or Del Sol ever be able to compete with a Mustang in terms of power? Not likely. I mean, you can make a 13-second street car out of a Honda just as easily as you can out of a Mustang, but if you wanna go much farther than that, the Mustang is the obvious choice. However, since you said, "This isn't going to be for any serious racing in competitions or anything, just screwing around with friends from street light to street light", the CRX or Del Sol should suit your needs just fine.