Question : How long do most people visit Paphos?
Answer : Of course you're not most people, but if you were, you'd stay roughly seven days.
Question : Is price more important than specific travel days for you?
Answer : In August, Thursday is your lowest-cost day to fly. Having flexibility in your travel plans means you can save more, so be sure to plan ahead when possible.