> how heavy is a NSFW classifier for a VPS?

Not heavy at all, they're really tiny in the grand scale of things and can easily run on CPU only unless you're wanna classify 100s of items per second.