Well all of this is very much do able, doesn't really involve any black magic or voodo, and just reflects the improvements due to standardization and incorporation of more features into a single box, if you will. Remember your talking about a Router with intelligence built in not just a simple hub.
No, the ip address no longer needs to be static. Some old routers may have required it but the limitation of available ip addresses has made that impractical and therefore improvement to accept either static or dynamic ips is built in.
Also the router has built in its own NAT/DHCP server so it can either accept static Local addresses or issue dynamic addresses to all members of the local lan. Use of static or dynamic on the local side is much debated when it comes to both troubleshooting and security, particularly when wireless is involved, but it is only a decision you make during the setup stage of the router. A local lan with a wireless element issuing DHCP ip addresses could mean that your neighbor could tap into your local lan by simply setting up his wireless computer to accept a DHCP address. There are other security elements that handle this but that is a simplification of one concern. When you want to control the lan and you only have a few member units static local addressing is often seen as a better approach. But that is a whole big topic by itself.
So there probably shouldn't be any reservation on the Dlink unit in general as it will do just what your friend indicates. Also, I doubt that he has any magic formula, maybe a few tweaks he discovered, but probably more not wanting to get into fine points and options until your ready.