This is also one of the mods on my wish list, I loathe the random Vampire attacks, so it would be very nice to see them stopped. I'm also hoping for a mod that allows you to cheat your ass off (I think after having played Skyrim for well over 800 hours on the 360, I'm entitled to cheat a little )
Another thing I was hoping for was of course the Unofficial Skyrim Patch, but sadly it seems this won't be a possibility according to the creator of it. Although we could TRY to petition Sony to get it up. I think Sony made the decision for no external assets is two-fold:
1) Strict copyright laws in Japan (I don't think Sony wants to get sued by Disney Japan, because some one modded in Light Sabers in Skyrim)
2) Preventing mods of an erotic nature (God knows how many Erotic mods I have seen the past years for Skyrim)
Seeing as how the Unofficial Patch despite using External Assets, doesn't infringe upon any of the two points I mentioned, it might be still be a possibility, however slight it might be.