Mala is INSANELY easy to install and configure and very customizable. You can have a very nice and very personal Mala front end if you put the effort and imagination into it. And it runs on MOST pcs without a problem.
Hyperspin has much higher requirements as far hardware and is not as customizable. It's also much harder to install and configure. Most people will agree that Hyperspin looks fantastic and is the nicest looking Frontend out there, so the extra work MAY be worth it to you.
Maximus Arcade is another front end a lot of people here on this forum use and enjoy. If memory serves me that particular front end will NOT work for console emulation, but I could be wrong. It's very nice looking, I would say it's in between Hyperspin and Mala as far as looks. I heard it's pretty customizable, but I doubt it's as customizable as Mala, but I could be wrong. To purchase this front end it will run you around 25 dollars.
All three are good choices.
If you are looking for easy configure and a highly customizable front end than go with Mala. If your looking for a beefier front end with higher requirements than go with Hyperspin. If you want something in between than go with Maximus.
If you want some good examples of how these front ends look so a search on YouTube.
Hope this helped a little.