My last NA Rx7 had over 215k on the original motor when I tore it apart to see how they worked.. Everything was still in spec.
You'll only run into longevity problems with the engine when you start modding, of course, that could be said of a lot of things.
Oil consumption is overblown, if you autocross all the time and drive the way I do through the mountains, you will use up to 1 qt every 5k (spread across the oil change interval), but that's still within the factory spec on my friends' new BMW (according to his manual).
The real ownership experience (as said above in various posts):
Check your oil every 2nd or 3rd fill up, top off if necessary.
DON'T start the car, move it 2 feet and then immediately shut it off. This will "flood" the car, which means you have to hold down the accelerator all the way ,crank for 10 seconds and then let it start. The easiest thing is to let the car run for two minutes when you move it, or, you can do like I do (warning: There's no Mazda support for this), which is to rev it up to 3k or so, and turn it off while the engine is decelerating.
Anything else is above.
They're great cars!
1 Mazda == Good. 4 Mazdas == More Gooder.