The titler is a pretty simple device. It was designed for cameras that you don't look through to focus, like the one in the picture. It holds the card near the minimum focal lenth, and is big enough to fill the frame, two things you're never quite sure about when you're looking through those pop-up metal things. It's not necessary for cameras that you can look through the lens, though, because you can just set the camera on a tripod (or table) and frame/focus the title card.
If you're interested in shooting some film, look for a Super-8 camera on eBay. Avoid regular-8 (usually just called 8mm), because you can't easily get the film for it anymore, if at all, and it was a pain in the but to handle, anyway. Super-8 comes in cartridges like video cassettes, and is simple to use. I like Canon super-8 cameras from the late 70's, usually called "Canon Electric" with a 3-digit number after them. They were surprisingly advanced for home movie cameras, very user-friendly, very much like modern video camcorders. You will also want a viewer to watch what you've shot.
Read up as much as you can about shooting film first, though. Black-and-white super-8 is, I think, your best bet to start. Come to think of it, now that Kodak stopped making Kodachrome, I'm not sure there is any more color super-8 readily available. Don't be put off by the price: a 3-minute roll of film, last time I bought one, was about 15 dollars, plus another 15 to process. Plus shipping, unless you live near a lab that processes it. BUT, it's an incredibly rewarding hobby, pretty much for the reasons you've started to list above. The first time you get a roll of film back and see that string of tiny images, it's really something.
If I were you, I'd ebay the titler. It's more of a collector's item than anything you'd want to try to shoot with.