Noise-wise, yeah you can hear the fan kick in but it's not really loud. No issues bothering other people nearby, no issues with the onboard speakers playing over the fan noise.
In regards to the Deck not having games designed for it, Valve has done a fantastic job laying the groundwork for this product. Go all the way back to the Steam Controller and Steam Link; while those products were not a huge commercial success for Valve, I can see all the lessons learned paying off with the Deck.
Wanna save some battery life and you're on your LAN? Stream the game from your beefy desktop. Controller layout not working? Every button is fully programable and removable. This thing has inputs out the arse. Touchpads, D-Pad, 4 extra under-side triggers. Wanna play a game that's not officially supported? 90% chance some fan has already made a community gamepad layout that's better than what the game maker would have made, you can download it and it works instantly.