Liked (most to least):
Destroy incoming Xenon fleet
Pays good and can be challenging
Deliver Ship
Fun to make ships or repair broken ones then resell to others at above market- like owning your own shipyard!
Retrieve abandoned ship
Fun way to get free exotic ships to reverse engineer while still getting paid some!
Deliver resources
Can be very challenging, and also a good way to unload extra resources
Escort trade ships
In FL you can 'challenge' most aggressors to make them target you instead of the convoy, so challenging
Build station
Lets you have a significant effect on the economy while a decent profit, especially if you can make the factories yourself
Scan asteroids
Laid back way to get paid for earning discovery points, and not uncommon to get 2 or 3 missions at the same time for same asteroids!
Sector patrol
Solid random combat which can be challenging sometimes
Scan for valuable cargo
Decent money if you have a fast ship, sometimes find things worth snagging with Cargo Bay Hacker
Hated (most to least):
Buy sector maps
Fly 50km to check a mission and its just another con artists selling info I already know
Scan ships for illegal cargo
Ugh! Almost never find anything- waste of time
Buy asteroid data
I keep accidentally accepting these and they rob you of limited exploration points
Multiple passenger drop
No waypoints and running all over the universe for a low pay
Covert Operation
Follow a slow ship for 30 minutes, then it flies through a xenon sector and pick a fight with a Q...

Defend Station
Not challenging because ships don't target you and bail rate is just too high in FL. I end up tons of bailed fighters which generally breaks the game.
Tour of a Lifetime
Not horrible, just long with low pay and requires a TP. It is a little better if you take 3 or 4 at the same time and can stack pay.