Well, if you invest enough time and money, it can still be a very usable system! In my case I can even run the fairly modern OS4.1, a very slow 'version' of Firefox, some great PPC games and things like Dosbox. But, only a very select few use their Classic Amiga as their main machine, I'm quite sure.
Advise? I dont think you should upgrade your machine with the purpose of it becoming your main machine. Just invest what you want to spend time/cost-wise and make sure you have fun doing so.