IMO - If you want meaningful (whatever that means in a videogame) RP, you need PvP; you can't threaten an NPC with Keelhauling!
PvP piracy is rarely going to pay well unless you focus on [Current Gold Rush] traders/miners, same as with real Piracy. There's a boom market for certain items/commodities and pirating Biowaste should return a net loss to the poor sod engaged in it.
There are plenty of issues with Piracy in-game, linked thread in previous post, but your desire to only engage with it in a limited fashion is not one of them.
Sure. But look at what FDev did :
1. Added Megaship and new structure cargo hold piracy. But… the payout is terrible.
2. Added high value targets, with like 10t of 100-200K a pop cargo. AKA 1-2M worth of stuff. Nice. but… next patch, LTD can be sold 800K a pop... So, back to Agri LTD piracy.
It's like mini crumps of piracy bread created in their bubbles with no awareness of the rest of the game. Neat, but useless stuff.
I would suggest the following things also : Make pirating components, data and raw engineering stuff a thing and put "special" commodities like hafmium as valuable as the new gems.
1. AKA have medical transports that carrry medical research worth millions, along with experimental drugs worth millions and pharma insulators. Then slap a solid escort for good measure.
2. Military hazardous material transports, with Hafmium, polonium (mat) and other goodies.
3. Imperial Navy Archelologists, with ships containing guardian paterns scans and guardian materials.
As you see, finding cool ideas of piracy targets is easy as pie. But we need better tools also.