I'm definately NOT the one to ask (I myself ask UNIX Qs all the time!) but I will say this; in short:
NO!
Enabling root can be a security problem even when you are NOT logged in as root. The REAL security issue that experts talk about when referring to the root issue is not the "oops, I deleted the System folder" problem -- since only those that are not morons (read: tech geeks like me and you) tend to even know about root let alone want to enable it (most folks could care less about this stuff -- can you picture a ten year old girl saying to her dad, "daddy can you enable root so I can by-pass your permissions blocks so I can download porn on the Internet?" I thought not).
The real problem is that once enabled, root can be a "backdoor" for professional hackers to gain COMPLETE CONTROL of your computer from remote access. Of course, for the average user, the odds of this type of thing happening are quite extreme -- after all, a hacker would first want to actually break in to YOUR system. Nonetheless, once you 'enable' root access it is like placing a door in a brick wall: once there is a door in a wall it is the easiest point of access; it's harder to break into a Castle that has NO drawbridge just a moat with crocks.
In otherwords, a professional hacker (read: not typical script kiddies) can use brute force to digitally break into your machine by trying to access every point of possible entry (ports are a good example). If they can access your root account, they can turn your machine into their bitch. If they merely gain access to your normal user account (even if it IS an administrator account) they have less power and cannot do as much damage (although simply deleting the hard drive would likely be enough for me to cry foul!).
I think that for MOST uses, sudo is sufficient. Personally, I'll tell you a little trick. When I want to do things that OS X won't let me do, I either TEMPORARILY change permissions to folders/files using SuperGetInfo or BatChmod (and now the Unix command line "chmod" command -- thanks SimX for your help) or ... and this is the biggie ... I simply boot into OS 9 and do whatever the heck I want!! You can do ANYTHING in OS 9: move folders that are for DIFFERENT users (heck, you don't even need to be an admin let alone a root user in OS 9 to reek havoc), copy icons onto System & Library folders (to customize the appearance of your system and make it look real cool (see my .jpg below), and make invisible files visible (like bin, sbin, private, etc. -- just use File Buddy or a similar tool).
The point is that there are MANY ways to do things that OS X normally doesn't let you do. And each of these ways is safer than using root!
That all said, I think root is cool.
