Do you know the exact model of motherboard? For example, ASRock's 790GX boards (A790GX, A790GXH, A790GM, & AOD790GX) all officially list AMD's Socket AM3 Phenom II CPUs (including the X4 980 & X6 1100T CPUs) on their list of supported CPUs, but the K10N78-1394 only goes up to the X6 1090T & X4 965.
There are a lot of AM2+ motherboards (as well as a lot of AM2 motherboards) that ASRock made, so see if you can find the exact motherboard from their page (http://www.asrock.com/mb/index.asp?s=#AllProduct), then click on "Support", & click on "CPU Support List". The list of supported CPUs may seem confusing, but it's because they identify them by AMD's official SKU; you can always match them up here (https://en.wikipedia.org/wiki/List_of_AMD_Phenom_microprocessors).
As to whether it's worth it... ultimately that's up to you, no matter what anyone else says. You're already aware that this is going to be an older system, so it's not going to be a top performer. However, if your board can handle the X4 980 or X6 1100T (or even the X6 1090T), that gives you a system with a 3rd-tier CPU (http://www.tomshardware.com/reviews/cpu-hierarchy,4312.html), which puts it roughly equal to a Skylake Core i3 or a Kaby Lake Pentium -- & depending on the motherboard's capabilities, you might be able to OC the Phenom II (those top-level ones are "Black Edition" unlocked CPUs) for a little extra performance. You would end up with a decent secondary gaming PC (one that will probably have issues with the most recent games, but older ones will be fine), or a really good HTPC.
EDIT: Well, there were a bunch of answers while I was researching mine. Long story short, it'll support the Phenom II X4 975 or 980, or the X6 1090T or 1100T. Those are absolute best Phenom II CPUs out there, & all 3rd-tier CPUs as I previously mentioned. You've got a PCIe 2.0 x16 slot, so you can plop a dedicated GPU into that;or (if you're using it as an HTPC) just use the onboard graphics. You're limited to DDR2 RAM, but if you have a 64-bit version of Windows max it out (16GB tops). Since you have SATA III ports, get a 250GB SSD as your primary drive & a couple of 1-2TB HDDs for storage.
Again, it won't be the best or fastest machine, but as a secondary gaming PC or HTPC it should do just fine.