Most people get turned on when they hear someone telling them about what they'd like to do to them later, though only if it's the right person and the right situation, of course! For kinksters, this tendency can become a fetish in its own right: dirty talk in a BDSM context can often be quite harsh and aggressive, and to an outsider might even seem humiliating or abusive.
Make sure before you try something like this that you've had some crystal clear conversations about it beforehand. For most people, there are some things that will turn them on and others that will be an instant mood-killer, so be as careful as possible, and make sure you know what those things are in advance. It's also important to ensure you aren't overheard by anyone who might feel uncomfortable about your dirty talk, particularly if your specific kinks are ones it might be easy to misinterpret.