What are Cyanogenmod's profiles good for?
Yes, you'll have to manually switch to Home profile when you come back home. Its what you can find in classic mobile phones.

If you want to automate it, there're plenty of apps for that: Tasker+Profile4Tasker (paid), AutomateIt (free), Llama (free), Locale+Profile4Tasker (paid)