A Rapier has many strong options that allow for it to have high damage output. It is especially effective in Corrupted expeditions because of how strong Thrust damage is. It can certainly be used as your primary DPS weapon in PvE. This is not as easy to do in PvP because it is very difficult to land basic attacks with the Rapier in PvP.