All I know is some of my favorite moments with video games were whipping out the old Game Genie, Gameshark, or Action Replay and fiddling with the systems (making my Gamecube region-free to play awesome Japanese-only games!) or tinkering with the game's for my own personal entertainment (going to the secret island in Goldeneye, changing Link's tunic color to gold, flying in Mario Sunshine, etc.)
Sony, though, in particular, is pretty awful about letting you play YOUR system and YOUR games the way YOU want to play them. And, truthfully, they have zero right to brick your system and make it unusable. They can point to their EULA's, but consumer protection laws trump their EULA's, and most sane judges have agreed that a "contract" you often didn't know existed when you bought the product is largely invalid, despite them trying hard to make you THINK they, the company, have more power than you do. Well, they don't.
Yes, pirating is illegal, but there's nothing illegal about tampering with a system you've already purchased. Play it normally, add homebrew, or use it as a football; it's your system, and even if Sony disapproves of you using it as a football, they can't legally ban you for using it in a way they don't like.