You use paddle bits when you need a hole, that's mostly round and generally the size you want with tearout expected. You use forstner bits when you want a very round hole, exactly the size you expect.
Running wires through a joist? Paddle bit.
Drilling a precise hole? Forstner bit