Eh. You're right about things being overhyped but you go too far in the opposite direction. Ruby/Rails is an effective combination for low-volume elevated-complexity latency-insensitive web-based software, the kind you might use internally to your business. Node is a useful tool for quickly writing nonblocking servers (much more useful when they use more than simply HTTP). NoSQL is effective when actually have a ton of data and with the right software (i.e. not Mongo) it can provide guarantees to do everything you want that's also mathematically possible on a data set that large.
And you're really right about how simple Github is - it almost makes up for the complexity of git itself. Git is a useful and powerful tool that is much nicer than the svn and cvs tools it replaced, and having distributed development available like that is quite effective, but you've actually got to bother to try and learn something about it (otherwise please stick with svn or whatever instead of whining about how a few modestly-cryptic commands and the implications of representing commit history as an immutable DAG are so hard to wrap your head around - this should be undergrad stuff and you've no business passing judgement on entire stacks if you can't grok it).