I'm not a gamer but color & sharpness is important to me. I forgot to mention that I do watch many dvd movies & youtube. Also I was told that some computers have a "tv tuner" & possibly I should look for a better monitor for the above?
The one on the top of the linked page is the one I have and like. Just be certain your computer has any one of the video connectors available on the monitor. My video card supports two DVI connectors and that's what I'm using. The monitor has, I believe a D-sub analog and DVI connectors. It does not have an HDMI port. At least I can't find one. I have been told there is no noticeable difference in picture quality between the two connectors. Almost all computers have a D-sub video connector.
The killer for me is that monitor does not have a stand that is height adjustable - something I feel all computer monitors (except wall mounted) MUST have. Since my desk cannot easily be raised or lowered (and I would not want to do that anyway as that would change my keyboard and mouse height), and I don't like to raise or lower my chair just to have my head in the right position to view my monitors, I want the most adjustment possible from my monitor stands.
I just put together a new system for me and put a couple of Samsung S24E650BW 24" LED PLS monitors on it. Obviously, these are a bit more expensive but I plan on keeping them for many years. So far, I am very happy with them.
BTW, for things like monitors, big screen TVs and other audio/video hardware, I recommend checking out B&H Photo. They almost always beat Newegg and Amazon prices - and typically, you get free "expedited" shipping too. I ordered mine late on a Tuesday night and received them Friday morning. Can't complain about that. But also, instead of just tossing the monitors in a box and throwing in couple of those large air baggie thingies for filler, the monitors were totally encompassed in bubble wrap, put in a large box that was then stuffed with those large air baggies. No way could they shift about and likely would have survived falling out of the truck at 70MPH!
Well, sure - but then budget is a relative term too. I could have easily spent $400 or more for each monitor, so some might consider those I got were budget. And of course, I did go with PLS panels knowing they cost more too.
That said, if you shop around, you can still find some good deals - especially if willing to go with a refurbished monitor. I note this new LG has height and pivot for $170 with an IPS display.
I look at it this way. While I totally understand and appreciate the fact many are on very tight budgets, if this monitor is something you will be staring at for potentially many hours each day for several years, do your eyes, neck and back a favor and invest in a monitor that will inflict the least suffering.
If you look at $70 or even an extra $100, spread that over 5 years, that's just $1.17 to $1.67 per month extra.
Of course, if this monitor is just for some secondary computer and used infrequently, then I would go very budget too.
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.