Nope. Non-modified/non-hacked machines were bricked by the update. That is part of why there was such an uproar about it. And some games do require you to update to v4.2 in order to play them (i.e. Wii Sports Resort).
Weird, never heard of someone with a brick which was not a hacked system.
While some games are tied to certain updates, which are actually loaded via the game DVD itself, no games are tied to a specific system software version. For example, see this website which discloses the specific software (off of the DVD game itself) required to run the game, as well as the system software running to obtain the info.
These guys know a lot about the Wii system software.
They also recommend not to update to system software 4.1, yet they are able to run Wii Resort.