its a matter of preference
here is a list of all honda engines w/ specs on each one
Currently the most sought after engine would be the K20 from the Integra/RSX type r in japan. This is an expensive motor and fitting it into the older generation hondas is not easy and it is very costly.
Most people use the B series motor which is the most popular and has been around for many many years with several variations on displacement and power. It was used in many cars, each being a little different.