I'm gonna try really hard to not be a Crossfit shill ITT (maybe I'll start a thread about it), but I thought I'd address a few of your concerns in general terms:
1. I've never wanted to be really muscular (or cock diesel fwiw), only healthy and fit.
1) Define fit? Does it mean you can run 10 miles? Play sports? Move your body weight around effectively? Push heavy things overhead? Be flexible?
2) Lifting weights isn't gonna make you huge. As an example, when I started xfit I was like 5'9, 150lbs. After 8 months with plenty of weightlifting I can deadlift ~90lbs more, squat ~45lbs more and do 20ish unbroken pullups, but I've gained all of 5 lbs. No one would ever accuse me of being a hulk, lol. I'm still looking to put on another 10-15 lbs, and I still won't look anything beyond slender. Most people do similarly - you can weight train without becoming a meathead.
2. Due to a lack of knowledge, I'm sure I could end up hurting myself by not using them properly.
This is definitely true. There's a million guides to this sort of thing, however, so it can be fairly easily remedied. Starting Strength by Mark Rippetoe is a fantastic book for learning the basic lifts.
3. I have used various machines in the past, for instance whatever the one you do calf raises on, but never stuck with it. Just don't have the motivation to go to the weight room since it's not exciting to me and "feeling the burn" doesn't appeal to me in the slightest.
1) Don't feel bad about hating calf raises - they're pretty worthless. If you're going to lift weights, you want to do big, compound movements that target lots of muscles. Squats, deadlifts, presses, cleans, etc.
2) There's definitely ways to incorporate weightlifting into exciting routines, but I totally understand where you're coming from. I know I got bored of doing the same 6 stupid lifts over and over again at the gym, which is a lot of why I switched.
4. At my University, to get to the weight room, you had to pass the bball courts. I never made it past the bball courts.
Make it a soccer field and I'm totally with you.
Ultimately, I like doing enjoyable activities that have a side effect of making me fit (bball, football, tennis, volleyball, soccer) rather than doing something I don't enjoy strictly for fitness.
This is def the right attitude to have. Only crazy people can do not-fun fitness stuff for long periods of time. Whatever you end up doing, make sure you enjoy it. I love what I do since it provides competition, camaraderie, and people constantly telling me what to do - I'd never have learned how to do a deadlift or a clean and jerk otherwise.
Insanity is more on the side of "strictly for fitness," but since I can do it in my basement and someone is constantly telling me what to do, some of my weight room concerns are alleviated.
I think in the end it comes down to what I said before - if it gets you off your ass and gives you the results you want, carry on my friend. You don't need to change anything unless you're unhappy with the routine/what you're getting out of it.