Yeah, "adding" height is pretty easy with books or reams of paper or boxes - though it may not be aesthetically pleasing which some in office environments (especially if they see clients there) may desire. Several years ago, I used a couple 2 in tall priority mail boxes and spray painted them black so they would not look too out of place.
But height adjustment stands also let you lower monitors too below normal fixed stand heights. And that can be desirable if your monitor sits up on a shelf, or as in my case, your desk has a hutch the monitors must sit under.
I don't know how you could devise a means for pivoting the monitor, however, without removing the stand and using a VESA mount arrangement.
Anyway, it does seem for just $9 more, the LG 24MB35P-B I linked to above has very similar specs to your 23MP47HQ, but comes with a slightly larger display (23 vs 23.8 inches) and a stand that supports height, pivot, swivel and tilt, compared to only tilt. The other difference is the 24MB35P-B supports DVI while yours is HDMI. But since the video signal in the DVI is exactly the same, as Bill M noted there is no quality difference concerns, or worries about audio either. So depending on what interface your card supports, you may need an inexpensive adapter with either monitor.
As far as your issue about tuners, monitors don't have tuners. Video displays that include tuners are TVs. There are TVs, however, that support computer inputs via D-Sub (analog), or digital inputs via DVI or HDMI inputs. In fact, most TVs today support computer input.
