I also had the same TV model in my bedroom up until early 2014 and I used it to play my SNES, N64, GameCube and Wii, although I had to route the composite video from those consoles through a VCR to connect to the TV's RF input.
Pulled mine out of my storage closet the other day and fired it up for the first time since 2005, Came right to life and was just like i remembered back in the way watching toonami and playing NES & Genesis, Hooked it up to an old vcr and watched back to the future last night, Theres something magical about oldschool analog tech. I have a 50 inch LCD and surround sound, and watching that old tape in mono was the most comfortable nostalgic experience I've had in a while. The label likes to fall off the back of these, so don't lose it.
Start letting people in your circle know you are looking for one... it seems eventually someone knowing someone will have an old one they have stored away and will just give it to you so they can be rid of it. Good luck, you'll love it.
A couple of options: 1 Get an RCA to F Adapter. Simple connection. 2. You can search for an RF adapter instead. The right one will have the AV connection used for SNES, N64, and Gamecube. Some out there are crappy so look for a good quality used one... maybe on eBay or a used game store.
