Home Networking in the Mac Universe

I just spent the last several hours banging my head against the wall trying to get my home network to behave again.

Here's the general pattern:

1. Tell Google my problem.
2. Sift through the results.
3. Try random suggestion.
4. One random thing starts working. Another random thing stops working.
5. GOTO 3.

Yeah...gotta love computers.

As I've witnessed many people I respect migrating over to the Mac universe, and thought about making the move myself, I've often wondered about the networking story for the Mac.

From what I've heard, everything in the Mac universe "just works."  Does this hold for home networking?

If my home network consisted of an iMac, a MacBook, and an AirPort, would everything "just work?"

Is there a home network configuration that exists that would allow me to move a file between computers without having to cringe and look away as I deliver the final mouse click?

Would going all Apple all the time save me from this endless (home networking) torment?