I've used the palomar for most everything for years and years with no problems.  I used it on all types of line as well. Simple and has worked perfectly for me. I'm sure there are several that are sufficient but no need to change if it's not broken

My favorite for "line to lure" is a uni-knot but I grew up with an improved clinch and I also use a snell quite a bit.

 

For attaching leaders (usually flouro to braid) I use two. The fg is probably the best but, the way I tie it, I sit or kneel on the leader spool to keep it tight. If that's not convenient I use a blood knot. I've tried a bunch of them and these are my two favorites with no close third choice. To be honest, I could get along just fine using nothing but the blood knot.

 

Over the years tying knots has gotten more difficult. The line has gotten thinner and my eye sight isn't as good. To make things worse my hands are calloused so it's hard to feel the line. 

 

There's always a way and I've had to resort to actually practicing knots to find ways around these difficulties.

I don't drop shot much but I do use a palomar for that and there are some loop knots I use for tying up crappie rigs.

I like the Pitzen or 16-20 knot a lot. It's a San Diego Jam with fewer steps.

The uni knot is a very easy knot to tie and it is very reliable.