I agree that big blocks are usually more suited to the power hungry drag racers. But both types of engine can be used for the same things. You can have a good handling big block powered car, and they don't need to be hugely heavy (Aluminium) and you can have a super powerful small block powered car.
My dream engine is probably a 302 Chevy with 9000rpm redline. My god, imagine the sound.