It's a grey area to be sure. Lots of the things that Google states can contradict one another, such as in your case: They want you to have authoritative backlinks from reliable sources, but they dont want you to pay for it. (Might get in their way of getting your Adwords dollars, lol)
In this case, look closely at what you are getting. Sites like YP, Chamber of Commerce all offer paid profile creations, with the paid profile links being of a higher visibility within their website. If you are getting a full profile page, with lots of ways for you to support your business or company then it could be beneficial. If you are getting a small, otherwise unfindable profile page with a anchor text optimized link directly to your site, I would stay away.
Think of the benefits of having the link. Is your link going to be placed somewhere it can be found, and when found, does the page that will be linking offer the user anything. How does the profile page help build upon your brand?
"If I were to pay for a profile with them, would I request for a "nofollow" link back to my site? "
Again, it depends on how they set up the profile, and how they set up their profiles for all the other businesses on that site. If Google sees the site as just a way to milk money out of people for paid backlinks, they will get hit and eventually so will you. I would do some investigating into the other businesses that have profiles on there, and see how they do in search results. Either way, one link will most likely not do a ton of damage to your reputation, but is that a risk you would be willing to take? Just boils down to what you feel comfortable with.