workstation with recent kernel - btrfs
workstation with older distro - xfs
server - xfs or ext3 (soon to be btrfs - because lets face it you want rollback!)
laptop/low power PC - jfs
I'm pretty sure RHEL5 wont let you choose anything but ext3. Truth be told it's stable as rock and very proven. XFS is faster and basically a reiserFS replacement. I think RHEL6 supports XFS, i think i read it in the release notes somewhere but havent looked.
JFS tends to consume the least CPU i use it on most my atom PCs, however the DB rebuilds are a little slow and it's less supported (although not had any problems personally).