Small ship PvE combat is my thing lately. CZs and RES sites. I am having a blast. You need a different mindset, embrace the weaknesses, and exploit the advantages. Folks that say things like 'there is literally no reason to do x when y pays better' aren't going to enjoy fighting in small ships.
But make a gunnery pass at 730 m/s and tell me that's not exciting and fun. Don't make it your mission to kill ships. Just zip around, get your tags in, fly top cover, drag and bag, evade. Take advantage of the speed and agility. I flew in a high intensity CZ last night. Spent about an hour there, and claimed 8 bonds in all. But I had so much fun I was grinning ear to ear. It doesn't matter much to me that I only got a handful of claims when the gameplay is that much fun. And our side won the battle, I took no damage, never even lost a ring. I am fighting my ship to it's strengths, while accepting the limitations. If you're dueling, jousting and generally looking for one v one fights you're not fighting to your strengths. Many times in that CZ I would get in a battle, start to feel it's too hot as they gang up on me, then see a laser light show in the distance and hit boost and leave the ship I was just battling at 40% hull or whatever and go find another more suitable target. I didn't get THAT kill, but so what? Maybe I'll kill him in a few minutes. This is the mindset you gotta have. If you can free yourself of the need to finish off every ship you engage you can have a really good time fighting in small ships.
Reading the posts I think players put too much importance on the payout, and not enough on the experience. Small ships aren't for everyone. Just like large ships aren't for me. Being a semi-static fortress killing everything that comes in to view is far less appealing to me than blacking out every two minutes because my ship is too fast for human physiology, even if the payout is far less.
For what it's worth, this is the ship I am flying. It's a moderately engineered Courier with low DPS, decent protection and high speed. It's not even finished and has three unused slots!
A ship builder, outfitting and comparison tool for Elite Dangerous
coriolis.io
It is so much fun to fly and fight in. This spring I hit Elite in both Exploration and Trade, leaving Combat as the last one. I want to hit triple Elite, it's been a goal since I learned it was a thing. But as someone who is only half-way through Dangerous I knew it would be a long road. In order to make it as enjoyable as possible, I wanted a small, fast, agile combat ship with reasonable survivability in PvE combat. So I built it (with the help of the folks around here). And it IS fun. Sure, I could be killing ships faster in my FDL, or a Vette (or plug any heavy hitter in here), but it wouldn't be as fun. Killing ships in a FDL or Vette feels like business. In the Courier it feels like art.