I have a Yashica-D that is a joy to work with. As others have pointed out, it's light enough to use handheld. I also have a Mamiyaflex with interchangeable lenses, it's well-built but rather heavy, so I only use it on a tripod (which is less often).
These sorts of cameras are often available used and shouldn't be too expensive. Just make sure you're getting a good lens, as many seem to come in versions with both desirable and less-desirable lenses - probably a pricing issue when they were first released.
The negatives are things of beauty. Try it, you'll like it.