As I understand it, PIOPS lets you specify the maximum throughput you are willing to pay for. It has no bearing on the latency/throughput you will see below the amount of IOPS that have been provisioned - you will still see latency spikes.

To answer the question added in the edit - no, PIOPS will not improve your database performance, as far as I can tell from the available information and my own benchmarks.