At first you might not see much use to it, but after awhile you may find you like certain things. I was in a similar situation when I first started dual-booting (I didn't go straight to Ubuntu, but it's where I landed), and now I'm planning on getting a computer specifically for Ubuntu.
I don't care a whole lot for Open Office, and I much prefer Photoshop to Gimp, but I've just grown to like Ubuntu because it's faster than Windows (unless you use Compiz-Fusion), it's got a great UI, and there are some freeware programs available for Linux that aren't available in Windows. For example, Amarok is an iTunes-like program (minus the DRM nonsense) that I've grown to really really like (I imagine its praises are probably sung by many Linux users) and I wish were available in Windows, same with a program called dvd::rip. I really think you might be amazed at the available freeware out there for Ubuntu.
It can also be very frustrating at first, but after awhile I certainly grew to like it.
I'm not an anti-Micro$oft fanatic (personally, I think Windows is a great OS), but Ubuntu is just fantastic at some things (like the multiple desktops, I use those all the time!). And the 3D effects in Compiz-Fusion are more than just eyecandy, they're very useful. Well, ok,
sometimes it's just eyecandy, but other times it's pretty useful (like the 3D cube). But even the things that
are eyecandy can be nice; like I like to have a raindrops effect just to break the monotony if I'm doing something uninteresting.
Even now it can be frustrating to me sometimes (like right now my Amarok isn't working and I can't figure out why; I'm going to restart after I finish posting

), but I still think it's worth it.
As for games, there are some interesting freeware games for Linux (and once in awhile you'll find proprietary games on Linux, too, like Quake 3 or some things like that), but all-in-all, I wouldn't use it much for games. I've heard some amazing success stories involving Wine, including people getting better performance out of Wine than in Windows itself, but all-in-all I don't really like Wine. I figure, I'm dual-booting, I've got Windows, and if I want to use a Windows program then I'll go into Windows. If I'm in Linux, I use Linux programs. A lot of people might disagree with me, but I just don't like Wine because it's finicky. I tried it and had some success with some things and no success with others.
But, at the end of the day, I would recommend Ubuntu to anybody who has the slightest bit of interest in it. It's a great OS. Sometimes I go into Windows and it feels refreshing, sometimes I go into Ubuntu and it's refreshing. They both have advantages; that's why I suggest either dual-booting or using two different computers.
So, to sum up an especially long-winded post, yes! Go for it!