Weight for "rally" and for rallycross are two different animals. For stage rally, the car is going to be relatively heavy regardless, seeing as it's going to be caged, has two people in it, and at very least a spare tire, jack, and some other gear. Plus a rally car has to be street-legal, so it has to have full lighting, catalytic converter, and other things that make it legal to drive on public roads.
For rallycross, all bets are off if you run in modified. One of the fastest MR guys in the country is Vaughn Micchie, who runs a Porsche 924S. His car is "lightweighted" to the extreme....all lexan, zero interior except a seat, no lights, fiberglass panels, and more. Unless you go to that extreme, a 924/944 is marginally competitive in a fast region. Dan Gugger runs a 944 in our region (MR) and though the car isn't heavily modified, he's quite a ways off the pace at the moment (though he'll get faster for sure). In slippery conditions, the 944 is great though, since it has more weight over he drive wheels than most other RWD cars out there. But if you know German cars, the "easy button" for rallycross for cheap is an e36 325i/328i. Our event last weekend in a highly-competitive MR class went 1-2 to e36s (granted, one was an m3), and the 328i that was 2nd is almost stock, agaisnt a class full of heavily built e30s, Miatas, BRZ, etc. A stock e36 for $2-3k will be compeititive right out of the box. As will a Miata. And I'm saying that as someone who owns a 924S and rallies an e30 (and daily-drove a WRX for a decade). I honestly would say that there is no way, no how my 924S would be faster than an e30 in most rallycross conditions, aside from going extreme like Vaughn has. Just my opinion though. I know a couple guys who stage rally 944s as well.
Can't speak much to Hondas since I don't know them well. FWD classes have a lot of competitive cars - anything from Civics to Focuses to Fiestas to Elantras and plenty of others. I will say, from 8-9 years of rallycross experience, that the FWD cars don't seem to be any more "relaible" than the older RWD cars - very few e30s or Miatas or e36s DNF locally, but we see plenty of FWD cars popping axles and stuff like that. May just be the drivers, IDK. But any car driven with mechanical sympathy will do fine. If you do stupid stuff, you'll break stuff.
I can't see I've ever seen a Prelude out at any of our large events, though plenty of Civics. Civic Si is the ticket, really.
For rallycross, lighter is generlaly better. Look at results - Miatas are very competitive, e30s (which are pretty light), and similar. Ralycross requires good car balance and quickness more than all-out power. Long wheelbase = less maneuverable in general. Weight balance matters too since you want traction.
What region do you plan to run in?