Aseprite should work fine with a Wacom stylus (e.g. Intuos). I’ve never had the chance to use a Cintiq, but it should work. Anyway there is no pressure sensitivity support at the moment. Please post again in case that the tablet doesn’t work.
Anyway I’ve to dedicate some time to provide more customization (buttons at the side to call customized commands, etc.).