It has its pluses and minuses. I suppose it depends on whether you typically can have fun by yourself when you're NOT traveling. If you're the type that always has friends around or gets bored/lonely otherwise, you'll probably hate it. On the other hand, if you sometimes enjoy the solitude, solo travel can be very enjoyable. I've taken a few solo pleasure trips (including Prague once, funny enough) and the best parts for me are the opportunity to do exactly what I want with the day and not follow anyone else's schedule. Also, there are certain activites I enjoy, like walking, peoplewatching and photography, which are great to do on your own.
I've got many years of primarily solo business travel, so the dining alone thing no longer fazes me. If you don't like it, I love going to local markets when traveling, so sometimes I'll dine in a park (weather permitting) with a camera, or in the hotel room, with a good book.