Hollywood couldn't resist Patrick Hamilton's cinematic, darkly sexual work, says Iain Sinclair. But can the films do the originals justice?