Is there any good mods for this game? As much as I've loved it all these years it needs a kick in the bum!

What mods do you have in mind? Improvements on graphics, or things such as extra campaigns?

Just anything in general. I'm guessing extra missions is more likely than improved graphics considering the games age, it still looks quite good.

Then I suggest starting with some really cool campaigns and missions, that are available here: http://www.gordoncz.com/blitzkrieg/index.html

Those were also mentioned in another thread. However, they are well done and guarantee you hours of hours of extra playtime.

After the collapse of Blitzkrieg portal the mods, texture and map packs gotten a bit scattered.
But like Rhineland said, the ones at GordonCZ will guarantee you hours of enjoyment. (Especially Achtung Panzer)

cdv's forum also covers some maps and mods. (like the Japanese voice pack for Rolling Thunder.)
http://forums.cdvusa.com/forumdisplay.php?f=39

There is also a few European fan sites, but most are are quite a hassle navigating on as their site language isn't English. Some of them have been posted in the rather dead cdv forum, but quite a lot of them aren't around ether anymore...

For a large amount of documented smaller mods and maps from bk portal, i recommend checking out Boltz Japanese fan site (that thankfully is in English.): http://www.geocities.jp/kwx50/en/index_EN.html

He also host tutorials for how to mod and make maps that are worth checking out.