The only cameras where going > 12MP makes sense are full frame SLR's where there is obviously a good size sensor and lots of light can be let in. These cameras should the be paired with nice big lenses to make the most of the huge sensor.
Any photography hobbyist should want as many pixels as one can get. There are no drawbacks (other than increased data size) in that. Signal/noise-ratio remains the same when you add more pixels, it does not go down. Small pixels do not increase noise, small sensors do. The more pixels there are, the more you can do in post processing, crop more, rotate with less visible artifacts, correct chromatic aberrations better.
The reason why this myth exist is in the habit of comparing massively magnified images. The problem with this is that when you go to pixel level and compare 10 Mp sensor too 20 Mp sensor, you're basicly comparing 100% of the 10 Mp sensors light sensitive area against 50% of the other sensors light sensitive are and this does not give proper result.
Anyhow, I do agree, that 4/3 format was a serious mistake, but the micro 4/3 format instead is promising (because of camera and lens size reduction).
Beware the new TTY code!