Now Dolly....having had engine failures in both singles and twins....I beg to differ.....the production of brown, semi-liquid adrenaline (which collects in ones boots finally)...is the same in both types....just with a more rapid onset in singles as I recall.
It more depends upon where and when rather than what type of aircraft. The one that wound down in cruise with an almost empty Chinook at the end of a flight with almost no fuel left was a bit of a ho-hummer but the one on short final with a 105mm howizter and A-22 bag of ammo with some internal pax on the hilltop was a bit more sporty....as was the one in the Hughes 500 coming off a 9800 foot mountain in Alaska. That is entirely too high for such events....gives one way, way, too much time to think about what is going on....combined with there being nothing but old growth forest under you for the surrounding ten miles.
I would imagine having a turbine disk go to bits and simultaneously cut the other engine into bits as has happened on some of the modern twins could be a bit moving.....but any engine failure in a single at night is bound to be a bona fide thrill.
Twins are no where as apt to generate the excitement that a single does when the donk goes away. Unless the boneheads in the cockpit decide to shut down the wrong engine....now that can be a real giggle.