Since you're after a RAID solution, I'm presuming the drive enclosure itself will be in a fixed location, with you bringing your Mac to it.
Here's a run-down on what I see your options being:
Best Solution
A good-quality network-attached storage device. This will give you Gigabit speeds (it'll connect via Ethernet) which is plenty quick enough. Plus, there are a good number of branded gigabit NAS solutions available. It'll be 'set up and go', usually configured via a web interface build into the NAS unit. You'll also have the option of hot-swappable drives, should you desire. Being networked, you've also got the possibility of accessing the drive from elsewhere (other locations, other machines) on your home network.
Next-Best (1)
eSata via an ExpressCard. But this is a bit fiddly given the extra component (the card). If reliability is key, go for a good brand of eSata enclosure, good Sata drive, and good card maker.
Next-Best (2)
Firewire 800. The speed deficiency compared to eSata isn't too bad. Plus you're removing the card issue. As an aside, one big thing which people overlook when comparing eSata to Firewire is that Firewire provides power too. For portable users it's fantastic to both connect and power a drive through one cable without needing an AC socket. But it seems that's not applicable to you anyway
Worst
Anything with a USB cable on the end
(edit: in your position where reliability trumps portability, and you're willing to perhaps shell out a bit more money in order to avoid compromises, I'd definitely go for the first option, with hardware RAID-1 mirroring across at least 2 separate physical disks of a good brand)