I want my sim to know a lot of people, have a nice house and have a good job.
Unfortunately, I'm not sure that any 1 profession will necessarily fulfill all of these criteria (Your fulfillment, not the Sims'
)
To simply know a lot of people: nothing has beaten getting to 5 in guitar, and go to the park and play for tips, either as a revenue stream/get paid to have fun practicing for a Music profession, or just a way to have fun and meet people. I've gotten huge long lists of people I know. Then would come the fun of calling them individually before they decay off your accquaintance list, but that's a different issue.
Have a nice house : I honestly feel you can do this with any profession, or none. When not dictated by challenge rules, I select one of the 'Beautiful view' lots, and build what starts as a 'studio' shack. No walls except the exterior, so everything is in one medium-large room. I expand the building's footprint as I can afford it (all hail the power of the wall/foundation dragger!!!!) and add walls as I start to get company that would want privacy while using the bathroom, or folks would want to sleep in one place while others' want to listen to the radio.
Have a good job: I've had fun with all of the professions, and scratched my head at a couple requirements for promotion. I think you can have just as much fun with a non-profession income like gardening and fishing, and selling off any/all production you can't use, or as an artist or musician or writer. You won't make many simoleons as steadily at first, but if you don't have a traditional profession sucking down you're time, then can eventually become very lucrative.
There is no wrong way to play, if you're having fun, you're winning!