Originally Posted By: artificialist
I just thought of something. Are the suicide doors of a Mazda RX-8 close enough to a having a sedan for the OP? I remember working with a guy who had small kids and it worked for him. Unfortunately, he was the same guy who had no compression at 130,000 miles. If the OP could know he was getting an RX-8 with a low mileage engine, it may be a good value for him.
For what it's worth, 2009-2011 RX-8s got a TON of upgrades to address the egnine failures in earlier model years. New cooling hardware, better oil supply, all-new PCM, etc. Also, it should be possible to find one that still has a good amount of warranty coverage left. Mazda's normal powertrain warranty is 5 years/60k miles, their CPO powertrain warranty goes out to 7 years/100k and ALL RX-8s come with an 8 year/100k mile warranty on the engine itself. If you find one that hit the road in late 2010 or 2011 and has good maintenance records, you should be set for a while. Might take a nationwide search, but definitely doable (hence my sig).
All that said, I think the RX-8 is the exception that proves the rule: small + lightweight + RWD + 4-door = basically nonexistent in the US. The RX-8 (barely 4-door) and the 1999-2006 BMW 3-Series (barely lightweight) are as close as it gets without being hideously old, and both of them involve some compromises.